Import and database fields

Submitted by paddyman on Sat, 2008-08-09 09:00 in Price Tapestry

Hi David,

I have a stock field in my database which I update manually for each product. When I import a merchant feed the stock field for that merchant looses its data. Is there anyway to exclude my stock field from emptying when an import is run?

Thanks

Adrian

Hi Adrian, This is a bit

Submitted by support on Sat, 2008-08-09 12:02

Hi Adrian,

This is a bit tricky as the products table (as you have discovered!) is emptied (per merchant) at the start of the import process.

However, as you are maintaining the stock level manually i'm assuming that there are aren't too many products so it is probably feasible to "remember" the stock level for every product and then re-instate it after import.

How many products (max per merchant) are involved?

Cheers,
David.

Hi David, Thanks for getting

Submitted by paddyman on Sat, 2008-08-09 12:19

Hi David,

Thanks for getting back. Is a small number of products so will take a copy of them before I import and add them again after.

Thanks

Adrian