[[Contribution] osc2amazon - oscommerce to amazon synchronization]

I´ve got the right mws on .config.inc.php since the beginning. Also got the right Market ID, although for my country it has the suffix  "771770".  So If I add it with a comma after the market place ID, then I get no connection to amazon. I was told by Amazon that I needed to include this suffix in order to reach Amazon Mexico.  So how do I put that in then?

 

Like if i put the suffix then when I click on Update Amazon List i get 

amazon Sync Items updating list...
step 1/3
RequestReport error

Thanks very much

[[Contribution] osc2amazon - oscommerce to amazon synchronization]

Hozone.  I changed in my DB the name of my pre existing column  "ean_code" to "products_ean". Then I ran admin/amazon_addproducts.php.

 

​It showed no errors, but also did nothing. Then I clicked on "update amazon list" and it says "write ok".  I went into amazon seller central and there is no product created.

[[Contribution] osc2amazon - oscommerce to amazon synchronization]

Oh Then I already have another column but it's called "ean_code" .   On which files of your great contribution do I have to change "products_ean" for "ean_code"?

[[Contribution] osc2amazon - oscommerce to amazon synchronization]

products_ean columns has to be added to the table products

For how to add, use phpmyadmin or plain mysql.

Hozone. I did ran the  SQL file that comes in your package since I installed it. The SQL went through without errors. This should have added the column right? If it had, then what might be the problem?

[[Contribution] osc2amazon - oscommerce to amazon synchronization]

@@abelux

yes, i'm sorry but i forget to add to mention that products_ean columns has to be added to the table.

 

Hello. Thanks for the fast response again.  How do I add  products_ean columns to the table?  To what table?  Actually I have a column in my product db which already has san numbers.  Sorry I understand coding but I´m not a master.  Thanks for the big help.

[[Contribution] osc2amazon - oscommerce to amazon synchronization]

HEllo. Thanks for the fast response. I ran that php "admin/amazon_addproducts.php" and got this

 

amazon Add Item 1054 - Unknown column 'p.products_ean' in 'field list'

select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_ean, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_status = '1' and p.products_id = '0' and pd.products_id = p.products_id and pd.language_id = '3'

[TEP STOP]

[[Contribution] osc2amazon - oscommerce to amazon synchronization]

Hello

 

I followed instructions and got my API credentials.  Been trying to use it, but there is no local products to import. Do I have to export to a physical list cdv and then transform it to text and then put it in the required folder?

 

Or should it create the list by itself?