Gross price or Tax included csv import

[pleasureandsex]

Hi there,

 

I'm struggling with a csv import. My wholeseller feeds a csv file with a suggested retail price. This price is tax included. When i try to import it in PS with Storemanager then a can't select the correct database field, because it isn't ther or i don't know it.

I see the fields: unit price, wholesale price, price, unit price ratio.

 

The wholesale price is the price i pay at the wholeseller, and the "price" field is the field that i import the Retail price to ( tax included ). Now what PS does is add an extra tax (19%) to it, so the bruto/gross price ( or tax included price ) has a double tax on it. Normally one should import the retail price whitout taxes in to the price field, but as i said, that price isn;t in the csv, only the one with tax included.-

 

Anyone ideas how to import to the GROSS/Tax included Databse field?

Anyone knowing what the unit price and unit price ratio mean?

 

Hope you guys can help me out!!

 

Thanks in advance

Erwin

[phrasespot]

that price isn;t in the csv, only the one with tax included

Load the csv to a spreadsheet program, insert a column and add a formula to deduct tax from prices, export as csv again

 

Anyone knowing what the unit price and unit price ratio mean?

Caviar - $14.72, 2-Ounce Jars (Pack of 2)

 

Price: $14.72

Unit price: $3.68

Unit price ratio: per ounce

[jruuhela]

Old topic.. But anyway Im having a same problem with import wizard. On my .csv i have prices tax included and the import wizard will add extra tax for them..

 

Is it really only way to use spreadsheet program and modify .csv??