.png.022b5452a8f28f552bc9430097a16da2.png)
you should compare an erp product to manually added product, here is some basic steps on how to do this:
How to Compare Product Entries in PrestaShop
1. Identify Sample Products
- Select one product manually created in the PrestaShop back office.
- Select one or more products imported from the ERP that show the editing issue.
2. Access the Database
- Use a database management tool (such as phpMyAdmin or Adminer) connected to your PrestaShop database.
- Products are primarily stored in the ps_product table, but product information is often spread across related tables:
- ps_product_lang (localized names/descriptions)
- ps_product_shop (shop associations)
- ps_stock_available
- ps_category_product
- ps_product_attribute (for combinations/variants)
- ps_image (for product images)
3. Query the Data
- Use the product IDs to view all fields for each product across relevant tables.
- For example, to see a product with ID 123:
SELECT * FROM ps_product WHERE id_product = 123; SELECT * FROM ps_product_lang WHERE id_product = 123;
Note: Export the rows as CSV or Excel files if easier to compare.
4. Look for Key Differences
- Missing Fields: Are there any null or missing values in the ERP-imported product that are present in the manual product?
- Data Format: Are there strange or unexpected values (e.g., numbers where text should be, or vice versa)?
- Associations: Is the imported product linked to the correct categories, languages, shops, and stock records?
- Default Values: Are default fields (like visibility, active status, price, etc.) set the same way?
- Combinations/Variants: If you use combinations, check ps_product_attribute and related tables.
5. Check for “Orphaned” or Incomplete Data
- Sometimes an ERP import creates a product entry but forgets a related table, such as missing entries in ps_product_lang or ps_stock_available.
- These “orphaned” records can break the product edit page.
6. Compare Product Metadata
- Also compare:
- Images (ps_image table)
- SEO fields (meta_title, meta_description, link_rewrite)
- Custom fields, features, and tags
7. Test Editing After Fixes
- If you spot a discrepancy, try manually updating the field(s) in the database for one affected product.
- Then test editing it in the PrestaShop admin to see if the issue is resolved.
- If successful, adjust your ERP import process or perform a batch fix for all products.