Import/Export

Phoca Cart - complex e-commerce extension
User avatar
Slava
Phoca Member
Phoca Member
Posts: 18
Joined: 07 Nov 2025, 18:39

Import/Export

Post by Slava »

Hello!

Joomla 6.0.0.
Phoca Cart 5.2.3 Beta 2

(A) The value of the parameter Export Download Limit Count has been set to 3.
With this setting, the export file contains 3 SKUs, as it should.
But all SKUs available on the site are being sent for processing, which accordingly takes considerable time.
Is it possible to send only 3 SKUs for processing (as specified in the Export Download Limit Count parameter value)?

(B)In the export file, in the «Specifications» field, Cyrillic characters are replaced with hexadecimal codes. For example, the word «Материал» is replaced with \u041c\u0430\u0442\u0435\u0440\u0438\u0430\u043b.
At the same time, Cyrillic characters in the «Title»(and description etc) field are exported correctly.

expect:
specifications
"[{""id"":10,""title"":""Материал"",""alias"":""material"",""value"":""Керамическая плитка"",""alias_value"":""keramicheskaya-plitka"",""group_id"":3,""image"":"""",""image_medium"":"""",""image_small"":"""",""color"":""""}]"

have:
specifications
[{""id"":10,""title"":""\u041c\u0430\u0442\u0435\u0440\u0438\u0430\u043b"",""alias"":""material"",""value"":""\u041a\u0435\u0440\u0430\u043c\u0438\u0447\u0435\u0441\u043a\u0430\u044f \u043f\u043b\u0438\u0442\u043a\u0430"",""alias_value"":""keramicheskaya-plitka"",""group_id"":3,""image"":"""",""image_medium"":"""",""image_small"":"""",""color"":""""}]"

How can Cyrillic characters be exported correctly?
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Import/Export

Post by Jan »

Hi,

a) unfortunately, there is even preprocessing where all the items will be stored to database, so there is no option to skip some items :-(

b) this is maybe related because the specification is multidimensional field which needs to be stored in JSON, so this is most probably to the translation to JSON format :idea:

Jan
If you find Phoca extensions useful, please support the project
User avatar
Nidzo
Phoca Professional
Phoca Professional
Posts: 482
Joined: 07 Nov 2018, 14:55

Re: Import/Export

Post by Nidzo »

Phoca cart lacks an intuitive way to import products and other data. By that I mean the mapping of columns from a CSV file. Something like that exists in Prestashop or WooCommerce when importing from a file.
Phoca cart and Joomla are rock solid combination but when you need to update stocks and prices of thousands of products everyday you need to look for alternative.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Import/Export

Post by Jan »

Hi, you can even try:

https://rolandd.com/products/ro-csvi

Jan
If you find Phoca extensions useful, please support the project
Post Reply