Markup and Taxes Columns in CSV - not sure what values to enter
Hello, I'm new to Aronium and I'm currently filling out my CSV product sheet so I can import my products. I've only used Margin % to calculate my selling prices in the past. I have a cost and selling price sheet I've used for years with my products in excel. Now I'm moving them to the CSV sheet for this POS system. Into my CSV sheet, I've entered my product cost and my current selling price based off of margin %. I've left the Markup column empty so far until I know what to do. Now, once it is loaded into the program, will it automatically calculate the markup since I have the selling and cost values entered? Do I have to enter the markup before uploading?
I also have 2 taxes to set, one at 5% and one at 6%. Do I put 11% in the tax column? If I do, is it going to create a new tax of 11%? I'm hoping the z-report will break down the total of each tax collected separately and not as one total.
Thanks in advance.
-
Hi Jason,
Please find the answers below.
Now, once it is loaded into the program, will it automatically calculate the markup since I have the selling and cost values entered?
No, price can use markup as information when editing a product, meaning that your sell price can be calculated based on markup but during product editing only. Once you save sell price, it will not be changed automatically on cost price change, you have to change it manually.
Do I have to enter the markup before uploading?
If you already have it in your Excel sheet, it is OK to enter it. Cost price, markup and sell price will be saved "as-is" during import, so you may find it useful for later.
I also have 2 taxes to set, one at 5% and one at 6%. Do I put 11% in the tax column?
No, there is a way to add multiple taxes in once cell. To add these two taxes for one product, enter "5|6", using "pipe" symbol as a separator. You can find some more info about CSV import here.
Hope this helps a bit.
Thanks, Aronium team.
Please sign in to leave a comment.
Comments
1 comment