Search the Community

Cheers, i have an issue... i am trying to transfer some products from an opencart 3.0.2 shop to the latest prestashop 1.7.7.3, so i wrote this query in phpmyadmin at opencart db and i got the fields that i wanted. (I leave this sql query here in case anyone want to do something similar. ps don't get confuced with the category id's) SELECT a.product_id, a.quantity, a.price, b.name, b.description, d.name FROM oc_product a LEFT JOIN oc_product_description b ON a.product_id = b.product_id LEFT JOIN oc_product_to_category c ON a.product_id = c.product_id LEFT JOIN oc_category_description d ON d.category_id = c.category_id WHERE a.status = 1 AND b.language_id = 1 AND d.language_id = 1 AND c.category_id = 10643 OR c.category_id = 10644 OR c.category_id = 10645 OR c.category_id = 10646 OR c.category_id = 10647 OR c.category_id = 10648 OR c.category_id = 10649 OR c.category_id = 10822 OR c.category_id = 10930 OR c.category_id = 10931 OR c.category_id = 10933 OR c.category_id = 10948 AND a.quantity != 0 GROUP BY a.product_id the results are good so i tried to import that. i followed the sample as i did with the categories before but the error of the title comes up "Ιδιότητα Product->available_for_order δεν είναι έγκυρη" the value is just 1 for being avaliable and it seems valid i save in utf-8 the rest are all good but i can not proceed becasue of that error, does anyone have any idea what goes wrong?

Good afternoon, We are trying to import an .xslx (or a .csv, it's irrelevant) with 1000 products approximately, but there's constantly the error of invalid additional_shipping_cost. We've almost have tried everything: empty, 1, 2, 3, other kind of values but nothing works. The mistake that appears is the following: [product] TINTA BRO LC-123 BLACK 20ML (ID: No ID) it can't be saved The property ->additional_shipping_cost is invalid What else could we try? Are we missing something? Any help is welcome. Thank you very much.

Good day! I am trying to import a csv which is a combination the content of my csv is: id; attribute; value 12714; Atribs:select:0; s1:1 12714; Atribs:select:0; s2:2 but i keep getting this error: Catchable fatal error: Argument 15 passed to ProductCore::addCombinationEntity() must be an array, string given ../controllers/admin/AdminImportController.php on line 1791 and defined in ../classes/Product.php on line 1193 Hoping that someone can shed a light

For reasons unknown when we do a CSV import in 1.5.3.1 all the items end up in home directory. This did not happen with 1.4.9. o4 1.4.10. The items are also not placed under the manufacturer either, so both are clearly defined and selected in the csv import table. I have attached one of the csv imports used.