Jump to content
Search In
  • More options...
Find results that contain...
Find results in...

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

DevmanExtensions
 Share

Recommended Posts

santur Collaborator

santur

Posted
Posted
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 сервера. На данный момент в модуль иногда получается зайти, но, при запуске любого профиля модуль очень долго грузится и, в конце-концов, появляется сообщение: Возникли проблемы с загрузкой некоторых данных на странице.

 

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

2022-11-10_17-02-48.png

Link to comment
Share on other sites

DevmanExtensions Experienced

DevmanExtensions

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

 

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

 

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

2022-11-10_17-02-48.png

 

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!

Link to comment
Share on other sites
1
1

DevmanExtensions Experienced

DevmanExtensions

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

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

cmd_Ao5TkCbnWl.png

cmd_WIT5GDRny6.png

 

ApplicationFrameHost_1SySGZ1ouP.png

Sorry so much by inconvenience but our hosting company (contabo) is solving now an error… we can check the status in next links:
 
 
Again, our apologies, but really cant do nothing more, only wait to be solved.

 

Link to comment
Share on other sites
1
1

  • 4 weeks later...
DevmanExtensions Experienced

DevmanExtensions

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

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

image.thumb.png.2cb4db391ceafbd07fa0ac316567d457.png

 

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!

Link to comment
Share on other sites
1
1

satt Enthusiast

satt

Posted
Posted

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!

Link to comment
Share on other sites

DevmanExtensions Experienced

DevmanExtensions

Posted
  • Author
Posted
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

 

image.thumb.png.edb4d3ef6cf712651150c72c519b870c.png

 

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...

  • +1 1
Link to comment
Share on other sites
1
1

satt Enthusiast

satt

Posted
Posted (edited)
14.12.2022 в 15:33, DevmanExtensions сказал:

 

Hi!

 

1.- @id

2.- @available

 

image.thumb.png.edb4d3ef6cf712651150c72c519b870c.png

 

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.

Edited by satt
Link to comment
Share on other sites

DevmanExtensions Experienced

DevmanExtensions

Posted
  • Author
Posted
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!

Link to comment
Share on other sites
1
1

  • 2 weeks later...
Focster2019 Contributor

Focster2019

Posted
Posted 
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?
Link to comment
Share on other sites

DevmanExtensions Experienced

DevmanExtensions

Posted
  • Author
Posted
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!

Link to comment
Share on other sites
1
1

Focster2019 Contributor

Focster2019

Posted
Posted
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 .

Link to comment
Share on other sites

DevmanExtensions Experienced

DevmanExtensions

Posted
  • Author
Posted
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)

  • +1 1
Link to comment
Share on other sites
1
1

Focster2019 Contributor

Focster2019

Posted
Posted (edited)

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.

Edited by Focster2019
Link to comment
Share on other sites

DevmanExtensions Experienced

DevmanExtensions

Posted
  • Author
Posted
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!

Link to comment
Share on other sites
1
1

DevmanExtensions Experienced

DevmanExtensions

Posted
  • Author
Posted
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!

Link to comment
Share on other sites
1
1

  • 3 weeks later...
Abbos1881 Collaborator

Abbos1881

Posted
Posted

Здравствуйте
У меня возник вопрос по обновлению остатков через google sheets. Я подключил к google sheets, но пока настроить не смог, так как не разобрался в обучении.
Задача: Модуль по планировщику CRON должен проверять в гугл таблице SKU товара и если совпадает, то обновлять количество товаров.
Как можно реализовать? Можете, пожалуйста, помочь
Спасибо

Hi
I have a question about product balance update throw google sheets. I connected google sheets, but I can't set up correctly, since didn't figured out in tutorial.
TASK: Module Import/Export PRO throw CRON have to check in google sheets - product SKU If it equal then update product quantity.
How to realize it? Could you help me? 
Thanks and sorry for my english

Link to comment
Share on other sites

DevmanExtensions Experienced

DevmanExtensions

Posted
  • Author
Posted
On 1/29/2023 at 12:30 PM, Abbos1881 said:

Здравствуйте
У меня возник вопрос по обновлению остатков через google sheets. Я подключил к google sheets, но пока настроить не смог, так как не разобрался в обучении.
Задача: Модуль по планировщику CRON должен проверять в гугл таблице SKU товара и если совпадает, то обновлять количество товаров.
Как можно реализовать? Можете, пожалуйста, помочь
Спасибо

Hi
I have a question about product balance update throw google sheets. I connected google sheets, but I can't set up correctly, since didn't figured out in tutorial.
TASK: Module Import/Export PRO throw CRON have to check in google sheets - product SKU If it equal then update product quantity.
How to realize it? Could you help me? 
Thanks and sorry for my english

 

Hi!

 

Following the tutorial to connect to Google drive API you won't have problems, else, our team can make it by a reasonable price. Open a private message and we will talk across it.

 

Thanks

Link to comment
Share on other sites
1
1

  • 1 month later...
yotya Newbie

yotya

Posted
Posted

Добрый день ! Подскажите, можно ли как-то привязать обновление товаров к производителю ? На сайте есть товары разных производителей с одинаковым SKU. Как указать модулю, что необходимо обновить остатки\цену для SKU конкретного производителя ? Заранее благодарен.

Link to comment
Share on other sites

DevmanExtensions Experienced

DevmanExtensions

Posted
  • Author
Posted
On 3/14/2023 at 10:03 AM, yotya said:

Добрый день ! Подскажите, можно ли как-то привязать обновление товаров к производителю ? На сайте есть товары разных производителей с одинаковым SKU. Как указать модулю, что необходимо обновить остатки\цену для SKU конкретного производителя ? Заранее благодарен.

 

Hi!

 

In case that you want sell same product from many vendors, yes, is possible, you can get a individual product for each vendor, you can add a "prefix" to "sku", like:

 

Vendor1-123456

Vendor2-123456

Vendor3-123456

etc...

 

The another possibility, if you want keep the sku (only get 1 product), the product data always be the last imported data, not matter the vendor.

 

I hope clear your question.

 

Thanks

Link to comment
Share on other sites
1
1

yotya Newbie

yotya

Posted
Posted

Это не совсем то, что я хотел уточнить. У меня на сайте товары разных брендов, но иногда у них совпадают артикулы (SKU) , особенно, когда артикул это число из 4-5 знаков. При обновлении остатков по одному производителю , количество на остатке может поменяться у товара другого производителя, имеющего такой же SKU. Как этого избежать?

Link to comment
Share on other sites

DevmanExtensions Experienced

DevmanExtensions

Posted
  • Author
Posted
On 3/14/2023 at 12:05 PM, yotya said:

Это не совсем то, что я хотел уточнить. У меня на сайте товары разных брендов, но иногда у них совпадают артикулы (SKU) , особенно, когда артикул это число из 4-5 знаков. При обновлении остатков по одному производителю , количество на остатке может поменяться у товара другого производителя, имеющего такой же SKU. Как этого избежать?

 

Understood. Added a "prefix" to all sku or use another identification that is not SKU.

Link to comment
Share on other sites
1
1

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing

Покупателям

Разработчикам

Полезная информация

Последние дополнения

×
×
  • Create New...

Important Information

On our site, cookies are used and personal data is processed to improve the user interface. To find out what and what personal data we are processing, please go to the link. If you click "I agree," it means that you understand and accept all the conditions specified in this Privacy Notice.

  I accept