Are there any incompatibility issues I would need to worry about in adding additional columns to tables in the database? I'm already using most of the available fields in the item table and I would like a place to store each items ASIN assigned from amazon. I don't need to be able to read or write this in either the POS or the Manager, I just need to be able to access it through SQL queries.
Adding columns to item table
Oct 30, 2008
5 Replies
I would like to know the same thing. Has anybody done that without problems?
you can add a custom columns in Item table with this statement
ALTER TABLE [Item] ADD [ColumnName] NVARCHAR([size]) DEFAULT('') NOT NULL
it's important a DEFAULT value, otherwise the Manager and the HQ Client can't create new items on database.... in addition, you must add the field on offline databases and hq databases (or viceversa) because the sync. procedures get all fields
antonio
I agree. A separate table with the ILC and ASIN as the 2 fields would work for you.
You could query out your combined table and import it into Amazon's item lister program.
c> Thanks for posting a reply Antonio - having said that, would it make more
yes, in addition the HQ allow to sync non standard table via TableSync..
antonio
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required