# import cost prices from ATUM plugin

Viewing 6 posts - 1 through 6 (of 6 total)
• Author
Posts
• #107480
Dimitris
Participant

Atum plugin saves the item cost price including taxes, so when you import cost prices to COG you cannot have the right net profit . Maybe an option that import the cost price from atum without the tax will solve this.

Either way you have wrong results and the plugin is not useful.

Also i saw that the profit margin in orders list is not working , every order has 100% profit margin .

Thanks

#107652
Moshtafizur
Moderator
Plugin Support

Hi Dimitris,

I hope you are well today.

It seems that you have asked the same question on the WordPress.org forum. We replied to you there.

Kind regards,
Moshtafizur

#107691
Pablo
Moderator
Plugin Support

Hi Dimitris,

This is the math you suggested to calculate the cost:

Now for the taxes. Every product has a tax class, so you can substract the taxes with the following operation: %cost% / (1+ %tax rate%) = cost(excl tax)

example

tax class: basic – tax rate: 24%

cost(incl tax) from ATUM: 10€

10€/ (1+24%)=8,064 €

The problem is the tax rate is based on the user’s location. Although the product does have a tax class, that class can have multiple rates, each one connected to a different location. How to get the correct rate in that case? The only way would be to get the default rate, or the first one or the one with the highest priority. Let me know if you have some idea or if I couldn’t see something.

Regarding the profit margin, it should be ok after my last release. Can you please make sure that the order has a cost registered? If it doesn’t have a cost, the profit will be 100% anyway.

#107735
Dimitris
Participant

Hello again,
you are right for the multiple rates in every tax class. In Greece we have mainly 2 tax classes and 1 tax rate in every class, so highest priority tax rate in every tax class will do the job, as you said. It’s critical to substract taxes because every calculation is wrong as shipping taxes are add up to the profit, if you use method Get price including tax…

Regarding the profit margin, my orders have cost calculated right and the profit/profit percent also right, but profit margin remain 100%

example.
order – cost – profit – profit percent- profit margin
39,60 € – 31,87 € – 7,73 € – 24.24% – 100.00%

i have checked this option:
“Adds order taxes like VAT to the order profit.
Will probably make more sense if Products > Get price method option is including tax.”

and this

Get price method

Get price including tax

because after importing from atum the prices have tax included.

Maybe this causing the profit margin issue?

#107790
Pablo
Moderator
Plugin Support

Hi,

I sent you a modified version (2.8.7-dev) of the plugin via WeTransfer with a new option I created for you:
– Compatibility > ATUM > Taxes > Subtract taxes from ATUM cost while using the “Import” or “Cost sync” options

Please, update the plugin and check if it helps.

Also, try to update the order again or use our recalculate tool to see if the profit margin will be fixed.

#107793
Pablo
Moderator
Plugin Support

Hi,

Can you please make sure that the products you’re trying to import don’t have the tax status option set as `none`? If they have, the subtract option won’t work.