Updating Supplier Info

Mar 02, 2006 5 Replies
D

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


Vote
Twitter Facebook LinkedIn
R

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

Vote
Twitter Facebook LinkedIn
R

How well do you know SQL?

RMSynergy

Vote
Twitter Facebook LinkedIn
R

How well do you know SQL?

Grant RMSynergy

Vote
Twitter Facebook LinkedIn
R

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?

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required