Модуль Import/Export Pro - XLSX -XLS - CSV - XML - JSON - Google Spreadsheets [Поддержка]

[santur]

08.11.2022 в 16:37, DevmanExtensions сказал:

This is an error from your MYSQL server, probably will be solved if you increase the directive "wait_timeout" in your server settings, put in contact with your hosting support team please.

 

Сайт на виртуальном хостинге и там нет возможности изменять настройки MySQL сервера. На данный момент в модуль иногда получается зайти, но, при запуске любого профиля модуль очень долго грузится и, в конце-концов, появляется сообщение: Возникли проблемы с загрузкой некоторых данных на странице.

 

Получается, что решить проблему никак не получится? 

[DevmanExtensions]

On 11/10/2022 at 12:07 PM, santur said:

 

Сайт на виртуальном хостинге и там нет возможности изменять настройки MySQL сервера. На данный момент в модуль иногда получается зайти, но, при запуске любого профиля модуль очень долго грузится и, в конце-концов, появляется сообщение: Возникли проблемы с загрузкой некоторых данных на странице.

 

Получается, что решить проблему никак не получится? 

 

Hi!

 

Not regrettably, I hope that you understand that this problem is not from our side, is from your server side. In case that your server can't edit your limits, we recommend you search another hosting, exist excellent hosting in "contabo" for example, with good price and features.

 

Thanks!

[Constantine144]

Добрый день, модуль не работает. Похоже у вас снова упал сервер(

 

Изменено 14 ноября 2022 пользователем Constantine144
замена скрина

[DevmanExtensions]

On 11/14/2022 at 10:38 AM, Constantine144 said:

Добрый день, модуль не работает. Похоже у вас снова упал сервер(

 

Sorry so much by inconvenience but our hosting company (contabo) is solving now an error… we can check the status in next links:

 

https://contabo-status.com

https://twitter.com/ContaboCom

 

Again, our apologies, but really cant do nothing more, only wait to be solved.

 

[nykivanvas]

Добрый вечер! Как выгрузить 2 и больше столбца с одинаковыми названиями?

[DevmanExtensions]

On 12/9/2022 at 5:58 PM, nykivanvas said:

Добрый вечер! Как выгрузить 2 и больше столбца с одинаковыми названиями?

 

By this way, the value of column "Name" will be also imported in column "Meta title" (if this column doesn't exist in your file or is empty.

 

Thanks!

[satt]

Hi!
I have some questions on XML import.
The structure is:
 

<offer id="SD00021842" available="true" instock="99">
	<price>141</price>
	<currencyId>UAH</currencyId>
	<categoryId>274</categoryId>
	<picture>https://site.com.ua/imagecache/full/1/5/15745.jpg</picture>
	<picture>https://site.com.ua/imagecache/full/1/5/15745/15745_2.jpg</picture>
	<model>SD26550</model>
	<stock_quantity>99</stock_quantity>
	<name_ua>Фум рідкий SD Plus 50 мл SD26550</name_ua>
	<description_ua>Фум (рідкий) SD Plus - герметик, застосовується для створення надійного нероз‘ємного з‘єднання різьбових деталей в системах водопостачання і опалювання. Об‘єм упаковки - 50 мл.</description_ua>
	<vendor>SD Plus</vendor>
	<param name="Вага нетто, кг">0,085</param>
	<param name="Країна виробник">Китай</param>
	<param name="Країна реєстрації бренду">Китай</param>
	<param name="Об‘єм, мл">50</param>
	<param name="Робоче середовище">Вода</param>
	<param name="Серія">SD265</param>
	<param name="Тип виробу">Фум</param>
</offer>

1. How do I import the offer id="SD00021842" to my SKU field?
2. How do I import the available="true" to my Status?
3. How do I import the Main image and the additional images if the XML has the <picture> tag repeated?
4. How do I import all the Attribute names if they given as param name="Вага нетто, кг" with their values within the <param> tags?

Thanks in advance!

[DevmanExtensions]

On 12/14/2022 at 1:04 PM, satt said:

Hi!
I have some questions on XML import.
The structure is:
 

<offer id="SD00021842" available="true" instock="99">
	<price>141</price>
	<currencyId>UAH</currencyId>
	<categoryId>274</categoryId>
	<picture>https://site.com.ua/imagecache/full/1/5/15745.jpg</picture>
	<picture>https://site.com.ua/imagecache/full/1/5/15745/15745_2.jpg</picture>
	<model>SD26550</model>
	<stock_quantity>99</stock_quantity>
	<name_ua>Фум рідкий SD Plus 50 мл SD26550</name_ua>
	<description_ua>Фум (рідкий) SD Plus - герметик, застосовується для створення надійного нероз‘ємного з‘єднання різьбових деталей в системах водопостачання і опалювання. Об‘єм упаковки - 50 мл.</description_ua>
	<vendor>SD Plus</vendor>
	<param name="Вага нетто, кг">0,085</param>
	<param name="Країна виробник">Китай</param>
	<param name="Країна реєстрації бренду">Китай</param>
	<param name="Об‘єм, мл">50</param>
	<param name="Робоче середовище">Вода</param>
	<param name="Серія">SD265</param>
	<param name="Тип виробу">Фум</param>
</offer>

1. How do I import the offer id="SD00021842" to my SKU field?
2. How do I import the available="true" to my Status?
3. How do I import the Main image and the additional images if the XML has the <picture> tag repeated?
4. How do I import all the Attribute names if they given as param name="Вага нетто, кг" with their values within the <param> tags?

Thanks in advance!

 

Hi!

 

1.- @id

2.- @available

 

 

3.- Really I don't know if this work, because this is wrong... can't exist same tag name in same node level... anyway, you can try with:

 

Main image: picture>0

Image 1: picture>1

Image 2: picture>2

etc...

 

4.- examples:

 

param>[email protected]  -> Вага нетто, кг

param>0 -> 0,085

 

param>[email protected]  -> Країна виробник

param>1 -> Китай

 

etc...

[satt]

14.12.2022 в 15:33, DevmanExtensions сказал:

 

Hi!

 

1.- @id

2.- @available

 

 

3.- Really I don't know if this work, because this is wrong... can't exist same tag name in same node level... anyway, you can try with:

 

Main image: picture>0

Image 1: picture>1

Image 2: picture>2

etc...

 

4.- examples:

 

param>[email protected]  -> Вага нетто, кг

param>0 -> 0,085

 

param>[email protected]  -> Країна виробник

param>1 -> Китай

 

etc...

Thank you for quick reply!

It helped
The module is extremely powerful but documented not good enough to not bother support.
Speaking about wrong XML structure. I agree it's not quite right. But it's Rozetka standart (ukrainian biggest marketplace). So we have to work with it.

Изменено 14 декабря 2022 пользователем satt

[DevmanExtensions]

On 12/15/2022 at 12:55 AM, satt said:

Thank you for quick reply!

It helped
The module is extremely powerful but documented not good enough to not bother support.
Speaking about wrong XML structure. I agree it's not quite right. But it's Rozetka standart (ukrainian biggest marketplace). So we have to work with it.

 

Thanks for your words! will be nice if you can rate in forum, is a minute for you and this will help us to continue making improves and offer better support! =)

 

About documentation: We know it and we go to improve it soon as possible.

 

About xml structure: really I don't know if exists a solution for it... did you try with method that I said you?

 

Thanks!

[Focster2019]

Good afternoon.
I am importing products from xml.
Images are transferred to products by reference.
Sometimes there is no image on the link (but there is a link to it). Can the module skip products if there is no image on the link?

[DevmanExtensions]

On 12/29/2022 at 12:07 PM, Focster2019 said:

Good afternoon.
I am importing products from xml.
Images are transferred to products by reference.
Sometimes there is no image on the link (but there is a link to it). Can the module skip products if there is no image on the link?

 

Hi!

 

Really this is not possible by default, we will have to make a custom develop for it. If you are interested, write us in private message and we will check it deeper and estimate the cost of it.

 

Thanks!

[Focster2019]

30.12.2022 в 10:05, DevmanExtensions сказал:

write us in private message

Thank you, I will write you about this in a personal message.

There is a question.
The supplier transmits the availability of goods with several values.
Available may be "yes" and "few"
No - "no".
If I specify one per choice value for presence, then it is taken into account..
How to specify both parameters?
That is, the available status must respect yes or few .

[DevmanExtensions]

On 1/3/2023 at 1:37 PM, Focster2019 said:

Thank you, I will write you about this in a personal message.

There is a question.
The supplier transmits the availability of goods with several values.
Available may be "yes" and "few"
No - "no".
If I specify one per choice value for presence, then it is taken into account..
How to specify both parameters?
That is, the available status must respect yes or few .

 

Hi!

 

In "Conditional values" of column "Status":

 

(==yes=1)(==few=1:0)

[Focster2019]

Thanks for the help.
There is another question
Now the module generates links by the name of the product Name - this way the links are very long and hardly readable..

The supplier gives the url of the product where there is a model. For example:
https://site.ua/ru/product/product-model1
How can you specify a condition, for example, if the url field contains https://site.ua/ru/product/ , then leave everything after this value.
So that in the end the value "product-model1" is substituted into the cell

This is how I will get brief product models and substitute them in the field for example sku. And then I will use it in the formation of links.

Изменено 7 января пользователем Focster2019

[DevmanExtensions]

On 1/7/2023 at 11:49 PM, Focster2019 said:

Thanks for the help.
There is another question
Now the module generates links by the name of the product Name - this way the links are very long and hardly readable..

The supplier gives the url of the product where there is a model. For example:
https://site.ua/ru/product/product-model1
How can you specify a condition, for example, if the url field contains https://site.ua/ru/product/ , then leave everything after this value.
So that in the end the value "product-model1" is substituted into the cell

This is how I will get brief product models and substitute them in the field for example sku. And then I will use it in the formation of links.

 

Regrettably this is not possible. For make it, you will need a custom develop. In case that you are interested, put in contact with us by private email and we will estimate the cost for it.

 

Thanks!

[DevmanExtensions]

On 1/7/2023 at 11:49 PM, Focster2019 said:

Thanks for the help.
There is another question
Now the module generates links by the name of the product Name - this way the links are very long and hardly readable..

The supplier gives the url of the product where there is a model. For example:
https://site.ua/ru/product/product-model1
How can you specify a condition, for example, if the url field contains https://site.ua/ru/product/ , then leave everything after this value.
So that in the end the value "product-model1" is substituted into the cell

This is how I will get brief product models and substitute them in the field for example sku. And then I will use it in the formation of links.

 

Regrettably this is not possible. For make it, you will need a custom develop. In case that you are interested, put in contact with us by private email and we will estimate the cost for it.

 

Thanks!