EAN/UPC barcodes

[mhs]

Evening guys.
Can anyone tell me in which table form the database i can find the column i would edit the EAN/UPC barcode info?

There is a column in the product table called 'sBarcode' but when i tried updating it nothing happened.

Thanks

[malbro]

Evening guys.
Can anyone tell me in which table form the database i can find the column i would edit the EAN/UPC barcode info?

There is a column in the product table called 'sBarcode' but when i tried updating it nothing happened.

Thanks

Brand, EAN, ISBN and UPC are all variables and the values are stored in the table 'User Defined Properties' under the variable ID, which in turn can be found in the 'Variable' table, however it is very difficult to edit the user defines values as they contain a second ID which is the index into the Product table.

Writing some custom code is probably easier then editing those tables directly.

[mhs]

Thanks, i began to think as much!

[Jan]

Or you could import them using a flat file - so you would just need the product id and the values in a csv file.

Regards,

[mhs]

Thanks Jan,

I'm assuming 'Barcode' would be the correct mapping? And would that auto update the second ID sugested by malbro?

[Jan]

Sorry, they are not available in a flat file import, you can import them using a hierarchical file tthough, which can have quite a simple format, this Mole End knowledge base article explains how to do that :

http://moleend.helpserve.com/Knowled...t---v8-onwards

The header name is the name of the variable you are trying to mport.

Regards,

[Jan]

The second id was referring to an internal linking field, which is usually the product reference, you include that in the file to tell Actinic which product you want to update.

Regards,