I need to update the pricing for a database of parts. I'm thinking I can use the import to overwrite the old prices?? If I only select ManufacturersP/N, Price, and List on the import will QW import overwrite the stale prices? I'm hoping that it will just update Price and List and effectively leave everything else alone.
There IS matching ManufacturersP/N to match up with.
When importing products (and also contacts) it is a good idea to label the columns on your worksheet appropriately so that you know which fields they will be going into in Quotewerks when you come to do the mappings. A second tip is to import the items into a newly created Test database first and then check the results, and then afterwards import them into the Live installation when you are satisfied.
The option that you will need to select will be the third option ......
Update existing products and append new products
and map the manufacturerpartnumber column to the column on your worksheet and then select the fields to update ..... list and price.
When attempting to do this update there are some choices in the import wizard that I may not be answering correctly. I end up with a "When in the update import mode, you need to specify the SeekColumn and SeekField on the destination tab"
I only selected the fields that I'm concerned with i.e. MfgP/N, Price, and List.
There is a mapping for "Text File Field"----> "Database Field" that I'm not sure if I need to do anything with.
Am I doing something wrong? I don't see where to specify the SeekColumn and SeekField on the destination tab
Hi Alan -
You need to tell it which field to map on. Generally, this is Manufacturer Part Number. So in this section map MPN to the appropriate MPN field on your spreadsheet: