1. Home
  2. Point-Of-Sale Software
  3. Updating Supplier Info

Updating Supplier Info

I have created about 4000 new items but left out the Supplier information in the Supplier tab. All the new items have the same supplier name. I have all the Item Lookup Codes. Is there an easy way to use excel or csv file to upload the Supplier info according to the Item Lookup Codes?

Thanks

Reply to
DanielSie
Loading thread data ...

You have a couple of options...

  1. Export all your item information into an excel file add the Supplier's Name then using the QSImport tool and reimport the items with 'Treat duplicate records as errors' turned off. This will add the Supplier to of those items. But you will need all the item information in the excel file otherwise when it updates the item if you are missing anything you will have to reenter it. Download QSCImport tool here,
    formatting link
    , must have access to CustomerSource.

  1. Import the ItemID, SupplierID, Cost, ReorderNumber, MPQ directly into the SupplierList Table using a tool such as EMS SQL Import ()

Rob

Reply to
Rob

How well do you know SQL?

RMSynergy

Reply to
RMSynergy

How well do you know SQL?

Grant RMSynergy

Reply to
RMSynergy

Reply to
DanielSie

Are there any other products with the same supplier id as the 4000 that you created or are these items the only ones but assigned to the wrong supplier?

Reply to
RMSynergy

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.