Jump to content
Sign in to follow this  
pleasureandsex

Gross price or Tax included csv import

Recommended Posts

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

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??

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More