Importing price lists

When importing a price list what happens if some items are not set up in inventory?  Do they just get skipped over or does the item get created and pricing added? 

Hoping they will just get skipped over as I don't want every item in our inventory but want it to be easy to update pricing changes from our suppliers.

Parents
  • 0
    TimV said:
    Do they just get skipped over or does the item get created and pricing added? 

    In Sage 50 Canadian, the price list import tool cannot create inventory items.  It can just barely update selling prices if everything is perfect.

    Bad data 'skipped over' is more like 'erroring out' and may eventually cause the process to run out of a system resource and crash, hang, or even start corrupting data.  I wouldn't rely on the item code matching process failing gracefully on say, 28,500 of 30,000 items - at best it will take a long time to run.

    As Richard suggests, export the list first, you'll have something to check back on (or even to re-import the old prices with), and an excel report on which prices changed.  Better to use an Excel vLookup or similar function in Excel to match up the new prices to the item codes and build a price list in Excel, then export that sheet as a CSV, add the header and import.

Reply
  • 0
    TimV said:
    Do they just get skipped over or does the item get created and pricing added? 

    In Sage 50 Canadian, the price list import tool cannot create inventory items.  It can just barely update selling prices if everything is perfect.

    Bad data 'skipped over' is more like 'erroring out' and may eventually cause the process to run out of a system resource and crash, hang, or even start corrupting data.  I wouldn't rely on the item code matching process failing gracefully on say, 28,500 of 30,000 items - at best it will take a long time to run.

    As Richard suggests, export the list first, you'll have something to check back on (or even to re-import the old prices with), and an excel report on which prices changed.  Better to use an Excel vLookup or similar function in Excel to match up the new prices to the item codes and build a price list in Excel, then export that sheet as a CSV, add the header and import.

Children
No Data