QUOTE(msff @ Apr 2 2008, 09:32 PM)
I use Dataport 5. Maybe it's slightly different, but did you mean adding columns directly into the spreadsheet? I tried that and there didn't seem to be any corresponding fields to map my custom price levels to.
Dataport 5 doesn't download (or upload) price level information.
The Price Level field is
part of the export file using DP4, which is why I still use it. The format I showed is how you list your price levels in the spreadsheet.
For example, say you have 3 price levels. Your cost is $2 for Widget A. You sell Widget A to retail at cost x 50%. It sells to WholesaleLeve1 1 at cost x 40%, and WholesaleLevel2 at cost x 30%.
The PriceLevel field in your Dataport 4 spreadsheet would look like this:
To automate populating the Price Level field, I use the CONCATENATE function in Excel to calculate the price levels based on cost. Cost is cell W2 on my spreadsheet, so your formula (for Widget A) would look like this:
I use the ROUND function to limit decimal places to 2.
If you need the installer for DP4, PM me your email address and I'll send it. You can have Dataport 4 and 5 installed on the same machine without issue.