SQL PrestaShop products to Odoo Online E-commerce Migration
Budget: €750 – €1,500 EUR
1. Context and Technical Requirements
The project consists of migrating the entire product content of our current e-commerce site (PrestaShop) to our new Odoo Online instance (Enterprise version 19.0+e).
Non-Negotiable Technical Constraints:
Platform: The choice of the Odoo Online platform is non-negotiable. Any offer must be based on solid expertise in this environment.
Access: The Odoo instance is a cloud version without direct SSH/DB access. The migration process must imperatively rely on the standard Odoo import method via CSV/ID/Excel files.
Reference YouTube resources:
Mastering Odoo: Importing Product Attributes and Variants Made Easy!
https://www.youtube.com/watch?v=SPgqN8fUkY8
How can I import product variants in Odoo 18 (This video seems the most realistic one using External IDs)
https://www.youtube.com/watch?v=fA6Wu7aFbqU
I will provide Odoo Administrator access for the import. I will also provide the complete dump of the production database in .sql format.
Source Platform: PrestaShop (euromobi.be)
Target Platform: Odoo Online (https://www.euromobi.odoo.com)
Data Volume: Approximately 522 products, 42 attributes, and around a hundred features.
2. Product Data Migration Scope
The objective is to migrate all product data, including complex aspects related to variants and pricing.
Fields to Migrate per Product:
Identifiers and Descriptions:
Product Short Description and Product Descriptions.
HTML Description: The complete description must be migrated while preserving the HTML semantic structure ($H1$, $H2$ tags, etc.). The provider must ensure correct placement within Odoo content blocks to maintain hierarchy.
Images and Media:
Images (Optimization: use image formats for the product page and an image for the zoom available in PrestaShop via resize if necessary).
Note: The project will be carried out without translation and in French.
There are no barcodes to migrate.
Prices and Variants:
Variants (characteristics and related values) as well as their prices.
Specific prices for quantity purchases (volume discounts).
Associated products (Cross-selling).
The ability to display prices as VAT Excl. 21% for B2B and VAT Incl. 21% for B2C.
3. SEO and Language Requirements
SEO migration is fundamental for ranking continuity.
301 Redirects: The provider must produce the 301 URL mapping table (old PrestaShop URLs to new Odoo URLs).
301 Table Reference: Link to URL mapping spreadsheet sample : https://docs.google.com/spreadsheets/d/14O4E6KrvNPsf2lpPZM3UtvMAM7zcj4mzEmLi63FzyCo/edit?usp=sharing
Languages param: The main language of the site must be French. Other languages (Dutch and English) must use the /nl/ and /en/ format in URLs.
_________________________________
Required Skills:
Solid experience with e-commerce migration.
Odoo Expertise (Imperative, especially in managing Odoo Online constraints).
Mastery of complex data export and import via CSV / Excel.
The project consists of migrating the entire product content of our current e-commerce site (PrestaShop) to our new Odoo Online instance (Enterprise version 19.0+e).
Non-Negotiable Technical Constraints:
Platform: The choice of the Odoo Online platform is non-negotiable. Any offer must be based on solid expertise in this environment.
Access: The Odoo instance is a cloud version without direct SSH/DB access. The migration process must imperatively rely on the standard Odoo import method via CSV/ID/Excel files.
Reference YouTube resources:
Mastering Odoo: Importing Product Attributes and Variants Made Easy!
https://www.youtube.com/watch?v=SPgqN8fUkY8
How can I import product variants in Odoo 18 (This video seems the most realistic one using External IDs)
https://www.youtube.com/watch?v=fA6Wu7aFbqU
I will provide Odoo Administrator access for the import. I will also provide the complete dump of the production database in .sql format.
Source Platform: PrestaShop (euromobi.be)
Target Platform: Odoo Online (https://www.euromobi.odoo.com)
Data Volume: Approximately 522 products, 42 attributes, and around a hundred features.
2. Product Data Migration Scope
The objective is to migrate all product data, including complex aspects related to variants and pricing.
Fields to Migrate per Product:
Identifiers and Descriptions:
Product Short Description and Product Descriptions.
HTML Description: The complete description must be migrated while preserving the HTML semantic structure ($H1$, $H2$ tags, etc.). The provider must ensure correct placement within Odoo content blocks to maintain hierarchy.
Images and Media:
Images (Optimization: use image formats for the product page and an image for the zoom available in PrestaShop via resize if necessary).
Note: The project will be carried out without translation and in French.
There are no barcodes to migrate.
Prices and Variants:
Variants (characteristics and related values) as well as their prices.
Specific prices for quantity purchases (volume discounts).
Associated products (Cross-selling).
The ability to display prices as VAT Excl. 21% for B2B and VAT Incl. 21% for B2C.
3. SEO and Language Requirements
SEO migration is fundamental for ranking continuity.
301 Redirects: The provider must produce the 301 URL mapping table (old PrestaShop URLs to new Odoo URLs).
301 Table Reference: Link to URL mapping spreadsheet sample : https://docs.google.com/spreadsheets/d/14O4E6KrvNPsf2lpPZM3UtvMAM7zcj4mzEmLi63FzyCo/edit?usp=sharing
Languages param: The main language of the site must be French. Other languages (Dutch and English) must use the /nl/ and /en/ format in URLs.
_________________________________
Required Skills:
Solid experience with e-commerce migration.
Odoo Expertise (Imperative, especially in managing Odoo Online constraints).
Mastery of complex data export and import via CSV / Excel.