Google Shopping Feed - where in access database

[thedoc01]

Does anyone know where the product details for isbn, brand, etc are stored in the Access database please?
It will be easier if the changes I wish to make are done via here rather than going through each product individually in the software itelf.
Anyone have any ideas please?

[fergusw]

UserDefinedVariables, which ISBN etc are, are stored in the UserDefinedProperties table.
It is a reference table which contains the references to the productID, the variableID (i.e. ISBN etc) and the content of the variable.

[thedoc01]

Emmmmmmmm
Not in my version of Sellerdeck 10 ???

Am I missing something?

[fergusw]

The [UserDefinedProperties] table has been there since version 8, if I recall.
When you say "Not in my version", are you referring to the table's existence or the data/variables?

[thedoc01]

Ah, I see now.
I cannot identify each product with it's associated settings within this table.
So, unfortunately, it is not really editable is it.
Thanks fergusw.

[fergusw]

It depends on what you mean by editable.
It is directly editable there, if you know the "nVariableID" of the variable you want to change (e.g. ISNB) and the Product reference (sContentID) of the product.

We had previously released a Bulk Edit Tool for SellerDeck which allows you to easily bulk edit user defined variables by section as one of its many features.
PM me if you are interested in purchasing a tool like this.