AnsweredAssumed Answered

Help with importing.

Question asked by tarheelme on Oct 24, 2013
Latest reply on Oct 24, 2013 by philmodjunk


Help with importing.


     I import data that enables me to price our retail sales floor. The data consists of carpet styles and pricing.  I import from a master database {manufacturer, style name, style number and price}. Manufacturer & style number is unique. From this, I identify styles I actually have within the store with a tick in a checkbox. My problem arises when it is time to update pricing. How can I delete records from my database that are not in the import (meaning they have been discontinued) and update pricing for records that have changed, along with adding new styles not currently in the database.




     Do not be alarmed. The smoke you see rising from my head has never caught fire.