Support » Plugin: Woocommerce osCommerce Sync » 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 3 years, 1 month ago by affsports.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Alejandro Aranda

    (@alexwing)

    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.

    Thread Starter affsports

    (@affsports)

    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
    
    • This reply was modified 3 years, 1 month ago by affsports.
    • This reply was modified 3 years, 1 month ago by affsports.
    • This reply was modified 3 years, 1 month ago by affsports.
    • This reply was modified 3 years, 1 month ago by affsports.
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Language id field not working’ is closed to new replies.