Newbie Here - D-Tools Forum

11-02-2009, 11:26 PM

Does D-tool have a exchange rate conversion and Excel import wizard for us Canadian Users?

Dwain

NareshN · 11-03-2009, 05:01 AM

The easiest way to do this would be --

1. Export the products you want to update to a CSV (you can do this in the Product Grid in MMPD)
2. Open CSV in Excel and insert a new column called "UnitPriceA" next to the current "UnitPriceA" column.
3. Rename the old "UnitPriceA" column to "OldUnitPriceA"
4. In the new UnitPriceA column apply a formula to convert old unit price to new unit price based on the current exchange rate. So the forumla would be OldUnitPriceCell * ExchangeRateFactor and copy this forumula for the full column.
4. Save CSV.
5. Import CSV back in MMPD and your UnitPriceA will be updated.

You can apply similar logic for cost etc.

**Ryan Brown** · 11-03-2009, 03:36 PM

One more thing on this - with a csv you need to save the calculated values as regular values - the csv will ignore the formula once the file is saved and re-opened unless you do this.

1. copy the entire column of calculated values (where your formula is)
2. then choose Paste Special
3. Select 'Values' from the list
4. Now the formulas are removed and only the resulting calculate values remain.
5. Save CSV and import into D-Tools to update your pricing.