Export failure at export products

Hello @ruba1956,

Thanks for reaching out.

I am sorry, but I was unable to understand the issue. Could you please elaborate on this, and would it be possible to provide us with screenshots of the CSV file? Also, please let us know which plugin you are using to export the cost.

Kind regards,
Moshtafizur

Hello Moshtafizur,

In the attached pictures you can see how I export them and the results,

Thanks in advance for your help.

Regards,

Ruud

Hi @ruba1956,

Thanks for sending the screenshots.

It seems to be a formatting issue in Excel. I think you would need to auto-fit the column width. To do so, in the Excel, select all columns on the sheet then go to the Home tab > Cells group, and click Format > AutoFit Column Width. You can read more about AutoFit in Excel here.

If you have any questions, then please let us know.

Kind regards,
Moshtafizur

Hello @moshtafizur01

I don’t agree with you. As you can see I send you a screenshot with imported CSV file in Notepad++

As you can see the amounts in column “reguliere prijs” are placed between brackets “2,49” and the amount that coming from cost of goods isn’t between brackets –> cost 1.02 <– both, and all other amounts should be between brackets and with (,) instead of (.)

So please can you adapt this in the plugin!

Regard,

Ruud.

Hi @ruba1956,

Thanks for explaining the issue in more detail.

I have escalated this with our development team. They will get back to you as soon as they can.

Kind regards,
Moshtafizur

Hi @ruba1956 ,

I just released a new version (2.8.5) with a new option I created for you.

Plese, first update the plugin and then, this is what you could try:

• Disable Products > Cost sanitization > Product export > Convert cost to number
• Try the next following option as None. If it doesn’t work, try setting it as Convert dots to commas .

Let me know if it helps.

Hi @karzin

It’s working good with Convert dots to commas.

With None it’s converting just the first row.

So I think we can close this issue.

Thanks!

Regards,

Ruud

Glad to hear it!

In that case, please consider leaving a review if you are enjoying the plugin/support. It would be much appreciated ??