Problems with import of products

[uwes2025]

Hi, maybe somebody could help me. My versions are: Joomla 6.0.2 and PhocaCart 6.0.0.

I exported some products as a csv-file to have an example-file. Then I added 1 new product exactly as the example product and modified some values. Then I deleted the example product, saved the file as .csv and imported that file. That worked. Then I tried to click the button "Import". But nothing happened. Nothing.

Does somebody has an idea where the problem could be?

Thanks, and best regards Uwe

Screenshot: https://imgur.com/a/Y1RrcqW

[Jan]

Hi, try to see javascript console in browser dev tools. It is ajax based, so see .e.g. in Chrome the Network / Fetch/XHR tab and see if there is no error when clicking on the button.

Jan

[uwes2025]

Hi Jan, thanks for your reply. I did this, and there is the following error:
Status 500
Internal Server Error
VersionHTTP/1.1
Übertragen702 B (81 B Größe)
Referrer Policystrict-origin-when-cross-origin
Anfrage-PrioritätHighest
DNS-AuflösungSystem

Answer:
error true
code 1265
message "Data truncated for column 'price' at row 1"

But in column "price" in row 1 is only the heading "price", in row 2 the german heading "Preis".

I noticed that the price format in the cart-backend is e.g. 1458, in the frontend 1.458,00, and in the csv-file it's 14.580.000. No idea why....that's why I kept the price format for the import file the same style as in the export file.

Best regards Uwe

[uwes2025]

Hi Jan, I think, I've got it. The "price"-field in Excel was formatted to "number", I changed it to "standard". The "price_original"-field was empty, I inserted a 0. No it worked with my sample file. I'll try it now with more products in it.

Thanks for your help.
Best regards Uwe

[Jan]

OK