How to add product ID for all my existing products

[Nakatika]

Hello,

 

Facebook Products Feed requiring field "Product ID". 

 

I have more than 1000 products in my list, but I did not fill the Product ID from beginning , because this field was not "must". 

 

How can I add ID's for all my products? 

[selectshop.at]

Product ID are added automatically, when you add products to your database. Prestashop works exclusively with ID's.

 

What exactly is your problem with facebook (add a printscreen of error message) ? Are you using a module which removes ID's on URL ?

[Nakatika]

Product ID are added automatically, when you add products to your database. Prestashop works exclusively with ID's.

 

What exactly is your problem with facebook (add a printscreen of error message) ? Are you using a module which removes ID's on URL ?

 Thank you for your reply.

 

I think facebook wants "product code". Print screen is attached.

 

[selectshop.at]

PS version in use is ?

 

How you are adding your products to FB ? With a module ? If yes than this module should be extract this information form you database. If you are adding manually your products, than you can export them WITH ID on your back-office.

 

 

EDIT: When I check the Facebook developers docu, so your error is more related to product feed upload and not really the product ID of Prestashop. If you are using a module for to add your products to Facebook, than you should contact the developer of this module.

[Nakatika]

PS version in use is ?

 

How you are adding your products to FB ? With a module ? If yes than this module should be extract this information form you database. If you are adding manually your products, than you can export them WITH ID on your back-office.

 

id.png

I adding with Date Kick. 

 

So what I need is REFERENCE (not ID). 

 

How can I add reference to all my products? 

 

PS 1.6.1.11

[selectshop.at]

In the meantime I've edited my answer. See here:

 

EDIT: When I check the Facebook developers docu, so your error is more related to product feed upload and not really the product ID of Prestashop. If you are using a module for to add your products to Facebook, than you should contact the developer of this module.

[selectshop.at]

 

 

So what I need is REFERENCE (not ID). 

Product references are EAN or UPC. In this case export your products and re-import WITH ID and same productname by adding this information.

[Scully]

Product reference can by anithing, not only EAN or UPC. However if you want to have real or meaningful values in this field, you have to update it manually.

If you just want to have anything there, update by SQL.

update ps_product set reference = id_product;

This SQL sets the referenc to the same value as the products ID.