Language id field not working
-
Hello
I have a oscommerce website in portuguese and english, the main language is portuguese.
the language_id of portuguese is 6 and english is 5.
When i put 6 on the plugin language field, only imports the products in english.- This topic was modified 6 years, 2 months ago by affsports.
Viewing 2 replies - 1 through 2 (of 2 total)
-
I update plugin for save the sql query for import products in the log file.
Activate debug mode and read file importProduct.log in root WordPress path, and paste in this support taks the query.
Thanks for you reply.
So i tried again to import 4 products in portuguese (language_id=6), but still imports in english (language_id=5) to.
Her is the Debug:Start Import Lang: AND language_id=6 Offset: 0 Limit:4 Query: SELECT p.*, pd.*, p2c.categories_id FROM products p LEFT JOIN products_description pd ON p.products_id=pd.products_id LEFT JOIN products_to_categories p2c ON p.products_id=p2c.products_id AND language_id=6 GROUP BY p.products_id ORDER BY p.products_id LIMIT 4 OFFSET 0 Products origin total: 4 {"products_id":"8000","products_quantity":"956.00","products_model":"SWL62","products_image":"articles\/SWL62FPF.gif","products_bimage":"","products_subimage1":"articles\/fifa-logo.gif","products_bsubimage1":"","products_subimage2":"","products_bsubimage2":"","products_subimage3":"","products_bsubimage3":"","products_subimage4":"","products_bsubimage4":"","products_subimage5":"","products_bsubimage5":"","products_subimage6":"","products_bsubimage6":"","products_price":"43.4600","products_date_added":"2010-05-23 12:21:30","products_last_modified":"2017-03-31 16:56:20","products_date_available":null,"products_weight":"0.00","products_status":"1","products_tax_class_id":"4","manufacturers_id":"2","products_ordered":"7.00","products_type":"","products_level":"0","units_id":"2","minorder":"0.00","sugorder":"1.00","products_mh":"0.0000","products_mw":"0.0000","products_ml":"0.0000","discount_code_id":"0","quantity_discounts":"","products_sort_order":"4","price_cost":"0.0000","local_arm":"","products_ecotax":"0.0000","language_id":"5","products_name":"MIKASA FUTSAL BALL SWL62","products_description":"MIKASA FUTSAL BALL SWL62","products_url":"","products_viewed":"2259","products_keywords":"MIKASA FUTSAL BALL SWL62","products_info":"MIKASA FUTSAL BALL SWL62","categories_id":null} {"products_id":"8001","products_quantity":"28.00","products_model":"FL450-YGR","products_image":"articles\/FL450-YGR.gif","products_bimage":"","products_subimage1":"","products_bsubimage1":"","products_subimage2":"","products_bsubimage2":"","products_subimage3":"","products_bsubimage3":"","products_subimage4":"","products_bsubimage4":"","products_subimage5":"","products_bsubimage5":"","products_subimage6":"","products_bsubimage6":"","products_price":"48.6667","products_date_added":"2010-05-23 12:33:44","products_last_modified":"2016-04-21 12:30:50","products_date_available":null,"products_weight":"0.00","products_status":"0","products_tax_class_id":"4","manufacturers_id":"2","products_ordered":"135.00","products_type":"","products_level":"0","units_id":"2","minorder":"0.00","sugorder":"1.00","products_mh":"0.0000","products_mw":"0.0000","products_ml":"0.0000","discount_code_id":"0","quantity_discounts":"","products_sort_order":"5","price_cost":"0.0000","local_arm":"","products_ecotax":"0.0000","language_id":"5","products_name":"Futsal Ball FL450-YGR","products_description":"Futsal Ball synthetic leather sewn (Size 4) <\/SPAN>FIFA Approved<\/SPAN><\/SPAN><\/P>\r\n \"\" <\/SPAN>Official FPF Ball \"\" <\/SPAN>EAN: 4907225840922<\/SPAN><\/SPAN><\/P>","products_url":"","products_viewed":"3446","products_keywords":"Futsal Ball FL450-YGR","products_info":"In the game of Futsal National Championship 1st Division, Cup of Portugal and Super Bowl, the official ball is the \"Mikasa-FL450 YGR\"","categories_id":null} {"products_id":"8002","products_quantity":"547.00","products_model":"FL400S-WGR","products_image":"articles\/novasintra_2.jpg","products_bimage":"","products_subimage1":"","products_bsubimage1":"","products_subimage2":"","products_bsubimage2":"","products_subimage3":"","products_bsubimage3":"","products_subimage4":"","products_bsubimage4":"","products_subimage5":"","products_bsubimage5":"","products_subimage6":"","products_bsubimage6":"","products_price":"24.0000","products_date_added":"2010-05-23 12:39:16","products_last_modified":"2016-04-21 12:30:50","products_date_available":null,"products_weight":"0.00","products_status":"0","products_tax_class_id":"4","manufacturers_id":"2","products_ordered":"229.00","products_type":"","products_level":"0","units_id":"2","minorder":"0.00","sugorder":"1.00","products_mh":"0.0000","products_mw":"0.0000","products_ml":"0.0000","discount_code_id":"0","quantity_discounts":"","products_sort_order":"5","price_cost":"0.0000","local_arm":"","products_ecotax":"0.0000","language_id":"5","products_name":"Futsal Ball FL400S-WGR","products_description":" Bola Futsal synthetic leather sewn (Size 4) <\/SPAN>Recognized ball FPF\"Sintra\" - Reply<\/SPAN><\/SPAN><\/P>\r\n In Divisions II and III and National Cups, beyond the \"Mikasa-FL450 YGR\"<\/SPAN><\/SPAN><\/P>\r\n \"\" <\/SPAN>EAN: 4907225481165 <\/P><\/SPAN><\/SPAN>","products_url":"","products_viewed":"1396","products_keywords":"","products_info":"In Divisions II and III and National Cups, beyond the \"Mikasa-FL450 YGR\"","categories_id":null} {"products_id":"8005","products_quantity":"-6.00","products_model":"SKV5","products_image":"articles\/SKV5.png","products_bimage":"","products_subimage1":"articles\/FPV.gif","products_bsubimage1":"","products_subimage2":"articles\/FIVB.jpg","products_bsubimage2":"","products_subimage3":"articles\/giravolei.png","products_bsubimage3":"","products_subimage4":"","products_bsubimage4":"","products_subimage5":"","products_bsubimage5":"","products_subimage6":"","products_bsubimage6":"","products_price":"19.4634","products_date_added":"2010-05-24 10:44:38","products_last_modified":"2018-05-23 09:49:55","products_date_available":null,"products_weight":"0.00","products_status":"1","products_tax_class_id":"4","manufacturers_id":"2","products_ordered":"68.00","products_type":"","products_level":"0","units_id":"2","minorder":"0.00","sugorder":"1.00","products_mh":"0.0000","products_mw":"0.0000","products_ml":"0.0000","discount_code_id":"0","quantity_discounts":"","products_sort_order":"5","price_cost":"0.0000","local_arm":"","products_ecotax":"0.0000","language_id":"5","products_name":"MIKASA VOLLEYBALL SKV5","products_description":"MIKASA VOLLEYBALL SKV5","products_url":"","products_viewed":"1858","products_keywords":"MIKASA VOLLEYBALL SKV5","products_info":"MIKASA VOLLEYBALL SKV5","categories_id":null} End Import
Viewing 2 replies - 1 through 2 (of 2 total)
- The topic ‘Language id field not working’ is closed to new replies.