Home Button  Buy Button 

Topic:   Importing CSV to Update Prices

By: StanPosted on: Feb 4 2021 at 10:52:14 AM
New user...I would like to use a CSV file to update component and assembly prices. I can't seem to find a way to get them to import properly - the prices don't get updated for the component tests that I've done. Is this possible? Here are the columns in the CSV:
Location ProductID ProductName UnitCost Quantity LineCost1 Text21
STORES 110002 Capacitor, Ceramic $0.01 1394 $7.25 each

By: GuestPosted on: Feb 4 2021 at 10:55:07 AM
After you've selected the columns you should see at the very bottom of the window is a checkbox to "update selected column"

If you've selected the part number and the supplier/price column then it should update.

By: StanPosted on: Feb 4 2021 at 10:55:09 AM
By price I mean "default supplier's standard price"

By: GuestPosted on: Feb 4 2021 at 10:55:38 AM
After you've selected the columns you should see at the very bottom of the window is a checkbox to "update selected column"

If you've selected the part number and the supplier/price column then it should update.

Reply - add a comment to this topic.

You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.

Topic:- Importing CSV to Update Prices


Enter the numbers.

Your name here is optional