Has anyone recently updated purchase pricing throu...
# csvimports
d
Has anyone recently updated purchase pricing through csv imports? A saved import I use for updating prices on items with many vendors/subsidiaries was missing the "Item Vendors X: Purchase Prices" field while I'm very certain it did have that before. If I add the field and then run my update the purchasing prices don't change on the record even though it said all records were imported succesfully. I also noticed that when I try updating all preferred purchasing prices it does give me CSV import errors, specifically
Drop ship/Special Order items must have a preferred vendor and a purchase price.
This error doesn't occur when I have a vendor purchasing price that isn't being updated by the CSV import. Also, when I remove all vendor purchasing prices from an item except for 1 I won't be updating, al the vendor purchasing prices are being added except that the actual purchase price is empty. Below is a screenshot of what that looks like. I have no idea what to try next, except for updating the items myself, but with 9 different prices per item this will take forever
d
Check a saved CSV import (for updating/adding item vendors) on my acc, all mapping still okay What "Advanced Options" are you using for the import? (overwrite missing; overwrite sublists; run scripts; etc) What you're trying to do is 100% doable, something's just happening wrong
Also, when I remove all vendor purchasing prices from an item except for 1 I won't be updating, al the vendor purchasing prices are being added except that the actual purchase price is empty. Below is a screenshot of what that looks like.
Not quite sure what you meant here. (was the data before 10 lines, and you were expecting only one line to remain?)
d
These are my advanced options, as far as I know they haven't been changed.
As for what I meant with that last part; I removed all purchasing prices from the item except for one. The one that remains isn't in my update. When I do the import now, all the vendor prices are added to the item, except the actual prices are empty (like in the screenshot)
Tried it again this morning, and it worked. Not sure if anything happened in between so I find it quite odd
d
Just came back to this Diderik, in your screenshot of options, it's using the non-inventory part form, maybe one of the items was
non-inventory for sale
, which don't have vendors?
non-inventory for purchase
and
non-inventory for resale
do have vendors though