PDA

View Full Version : Import Price List


dlaery
08-18-2004, 05:02 PM
I export my item list and edit the different price levels and cost.
Then import back as an iif file. That works fine.
To streamline the file down, minus all of the other columns I don't edit, I exported an Excel file from Qbks, with the Item, Cost, and 3 other price levels. I would like to edit those and import back.
I tried the mapping in Qbks, it would let me import the cost, but not the different price levels.
Is there a way to do this with an Excel file?
Or, can I delete the columns I don't need in the iif file and only import the columns I want to change?

gibbo
09-24-2004, 08:43 PM
I have not tried this, so cannot be sure. However, the mapping tool is virtually the same as the IIF. Both produce a text file for import. If it does not work in one, you could expect it not to work through the other. But give it a try - if the fields are available.
There does not appear to be any ability using xml to alter these either.