Transferring data from the CRM to the site
Previously, the transfer of data from the CRM to the site worked, now it has stopped working, tell me why this happened, there are no errors in the logs https://crm-onebox.com/en/support/online-stores/11256-eksport-informatsii-o-prod... -v-prestashop/
Original question is available on version: ru
Answers:
https://box.generator.ua/admin/auto/action/hour/edit/
at the moment you have disabled actions for exporting information about products in prestashop
at the moment you have disabled actions for exporting information about products in prestashop
08.11.2021, 14:36
Original comment available on version: ru
Turned off Export when it stopped working.
08.11.2021, 15:25
Original comment available on version: ru
Dobrovolskaya Lyudmila wrote:
Action enabled but nothing works
I started both actions in manual mode - everything works, the connection to the Prestashop database is active and requests are being processed.
09.11.2021, 15:52
Original comment available on version: ru
Availability from the price list does not pull up on any site
09.11.2021, 17:19
Original comment available on version: ru
Let's look at some example of a product - I'll point out where the data is transferred to the PrestaShop database - perhaps something has changed.
10.11.2021, 14:34
Original comment available on version: ru
Here is a product
https://box.generator.ua/admin/shop/products/11512/edit/
The article matches the site 101337-41
Here is the item on the website
https://vitaltechno.ua/91-benzinovye-generatory/12014-generator-vitals-master-kl...
In SRM it has a different price and availability
In transmission automation
https://box.generator.ua/admin/auto/action/hour/edit/
data on
- article number
- transfer of price and availability
- Selected brand
But the data is not being transferred.
https://box.generator.ua/admin/shop/products/11512/edit/
The article matches the site 101337-41
Here is the item on the website
https://vitaltechno.ua/91-benzinovye-generatory/12014-generator-vitals-master-kl...
In SRM it has a different price and availability
In transmission automation
https://box.generator.ua/admin/auto/action/hour/edit/
data on
- article number
- transfer of price and availability
- Selected brand
But the data is not being transferred.
11.11.2021, 10:20
Original comment available on version: ru
MySQL [vitaltechno]> select * from `ps_product` where `reference`='101337-41' limit 1;
Empty set (0.024 sec)
MySQL [vitaltechno]> select `id_product`,`reference` from `ps_product` where `reference` LIKE '%101337-41%';
+------------+------------+
| id_product | reference |
+------------+------------+
| 12014 | 101337-41 |
+------------+------------+
1 row in set (0.038 sec)
MySQL[vitaltechno]>
your article on the site does not match those in OneBox
at least in this example - there is a space before the article on the site, so it does not find the corresponding product for updating
Empty set (0.024 sec)
MySQL [vitaltechno]> select `id_product`,`reference` from `ps_product` where `reference` LIKE '%101337-41%';
+------------+------------+
| id_product | reference |
+------------+------------+
| 12014 | 101337-41 |
+------------+------------+
1 row in set (0.038 sec)
MySQL[vitaltechno]>
your article on the site does not match those in OneBox
at least in this example - there is a space before the article on the site, so it does not find the corresponding product for updating
11.11.2021, 17:28
Original comment available on version: ru
Good morning. I will deal with this issue from the software side of the store. For Vitaltechno and Generators, the reference field was cleared of spaces. Vital had two items on Generators 17. Check for updated information for these items.
15.11.2021, 09:05
Original comment available on version: ru
Price has changed, availability hasn't! On the Vitaltechno website, article 101314-19. We had 84370 UAH on our website under the order, in the price list of the supplier 84366 Available. After downloading on the site, the price is 84366 UAH, the availability has not changed (on order)
15.11.2021, 16:05
Original comment available on version: ru
Dobrovolskaya Lyudmila wrote:
Price has changed, availability hasn't! On the Vitaltechno website, article 101314-19. We had 84370 UAH on our website under the order, in the price list of the supplier 84366 Available. After downloading on the site, the price is 84366 UAH, the availability has not changed (on order)
From the OneBox side, there are no stocks of this product in stock, respectively, the stock is reset to 0.
Requests are being made:
UPDATE `ps_product` SET `quantity` = '0' WHERE `id_product` = '14862'
UPDATE `ps_stock_available` SET `quantity` = '0' WHERE `id_product` = '14862'
15.11.2021, 17:06
Original comment available on version: ru
we made a special setting so that the data was taken not from the warehouse, but from the availability checkbox
15.11.2021, 17:50
Original comment available on version: ru
Good afternoon! what about data transfer?
16.11.2021, 14:57
Original comment available on version: ru
Dobrovolskaya Lyudmila wrote:
we made a special setting so that the data was taken not from the warehouse, but from the availability checkbox
specify the name of the setting you are talking about?
16.11.2021, 16:19
Original comment available on version: ru
Setting "availability" https://crm-onebox.com/en/support/online-stores/11256-eksport-informatsii-o-prod...
16.11.2021, 16:59
Original comment available on version: ru
Dobrovolskaya Lyudmila wrote:
Setting "availability" https://crm-onebox.com/en/support/online-stores/11256-eksport-informatsii-o-prod...
Fixed - in both actions, the setting "When unloading availability to availability in the warehouse, add the values of the "Availability at the supplier" fields for active product suppliers who have the product in stock" is available
Specify in the desired action and check after the unloading is triggered.
17.11.2021, 15:28
Original comment available on version: ru
Good afternoon, Maxim! Availability does not change
18.11.2021, 15:40
Original comment available on version: ru
Dobrovolskaya Lyudmila wrote:
Good afternoon, Maxim! Availability does not change
And why should it be changed?
We look at the example of the product https://box.generator.ua/admin/shop/products/162457/edit/ - the balance in warehouses is 0, the numerical value of the "Availability from the supplier" field = 0.
If the supplier had a number (available balance) in the availability text, it would be as it should.
18.11.2021, 15:47
Original comment available on version: ru
We just need that if the product is in stock at the supplier, then it should also be available on the site, we do not have this value in all products, initially we needed it that way. To do this, we finalized the "availability" setting https://crm-onebox.com/ru/support/online-stores/11256-eksport-informatsii-o-prod...
19.11.2021, 11:56
Original comment available on version: ru
Dobrovolskaya Lyudmila wrote:
We just need that if the product is in stock at the supplier, then it should also be available on the site, we do not have this value in all products, initially we needed it that way. To do this, we finalized the "availability" setting https://crm-onebox.com/ru/support/online-stores/11256-eksport-informatsii-o-prod...
I don’t see a single word there that if you + have a supplier, then some value should be transferred to the remnants of prestashop
I can modify the checks so that if not a number is specified, but the supplier has a tick "In stock", then transfer prestashop 1 in stock (if there is no stock in stock) - it will take 1 hour
19.11.2021, 14:20
Original comment available on version: ru
See, right here
https://1b.app/ru/support/online-stores/11256-eksport-informatsii-o-produktah-v-...
We wrote an example on the availability of goods (tick)
It was fixed and everything worked great
If the checkbox is not checked, the product is out of stock, the tick appears - in stock. Now it doesn't work, how can we fix it?
It is just necessary that if the item is in stock, the item is in stock on the site, in other cases it is not available, it's standard, what needs to be done to make it work like this?
On the example of this product, you can check
https://box.generator.ua/admin/shop/products/7700/edit/ - It's in stock
Site "out of stock"
https://vitaltechno.ua/91-benzinovye-generatory/1663-generator-fogo-fv-17001rte?...
https://1b.app/ru/support/online-stores/11256-eksport-informatsii-o-produktah-v-...
We wrote an example on the availability of goods (tick)
It was fixed and everything worked great
If the checkbox is not checked, the product is out of stock, the tick appears - in stock. Now it doesn't work, how can we fix it?
It is just necessary that if the item is in stock, the item is in stock on the site, in other cases it is not available, it's standard, what needs to be done to make it work like this?
On the example of this product, you can check
https://box.generator.ua/admin/shop/products/7700/edit/ - It's in stock
Site "out of stock"
https://vitaltechno.ua/91-benzinovye-generatory/1663-generator-fogo-fv-17001rte?...
23.11.2021, 20:31
Original comment available on version: ru
Could you suggest what is wrong, please?
24.11.2021, 15:11
Original comment available on version: ru
Dobrovolskaya Lyudmila wrote:
If the checkbox is not checked, the product is out of stock, the tick appears - in stock. Now it doesn't work, how can we fix it?
It is just necessary that if the item is in stock, the item is in stock on the site, in other cases it is not available, it's standard, what needs to be done to make it work like this?
I have already indicated above that availability is transmitted as an integer value of the sums of balances and availability from suppliers.
If the refinement you specified should work differently, please be so kind as to ask a question in the appropriate topic to the appropriate performer, who will clarify this issue for you.
For my part, I pointed out how the logic works - and I do not observe any obvious errors in it.
24.11.2021, 15:29
Original comment available on version: ru
Maxim, let's make a revision that will check the standard checkbox "availability" - if the checkbox is checked, then the presence of the site is transmitted integer = 1, if the checkbox is not checked, then the product on the site should be out of stock. I'm waiting for an invoice
24.11.2021, 18:02
Original comment available on version: ru
25.11.2021, 12:26
Original comment available on version: ru
Completion paid, we are waiting for execution!
26.11.2021, 10:36
Original comment available on version: ru
Improved the setting "When unloading the availability in the absence of availability (quantity) in the warehouse / suppliers - transfer the availability in accordance with the base field "Product in stock""
How it now works in conjunction with the setting "When uploading stock to stock, add the values of the "Availability at supplier" fields for active suppliers of the product who have the product in stock":
1. if both settings are not set - it is transmitted as the presence of the amount of product leftovers in warehouses
2. if the setting "When unloading the availability to the availability in the warehouse, add the values of the "Availability at the supplier" fields for the active suppliers of the product who have the product in stock" - the amount of availability from the supplier is added to the quantity in the warehouse
3. if the setting "When unloading the availability in the absence of availability (quantity) in the warehouse/suppliers - transfer the availability in accordance with the base field "Product in stock"" and the quantity in the warehouse/suppliers is not present - the availability of the product will be transferred according to the checkbox "Product in available" (0/1)
How it now works in conjunction with the setting "When uploading stock to stock, add the values of the "Availability at supplier" fields for active suppliers of the product who have the product in stock":
1. if both settings are not set - it is transmitted as the presence of the amount of product leftovers in warehouses
2. if the setting "When unloading the availability to the availability in the warehouse, add the values of the "Availability at the supplier" fields for the active suppliers of the product who have the product in stock" - the amount of availability from the supplier is added to the quantity in the warehouse
3. if the setting "When unloading the availability in the absence of availability (quantity) in the warehouse/suppliers - transfer the availability in accordance with the base field "Product in stock"" and the quantity in the warehouse/suppliers is not present - the availability of the product will be transferred according to the checkbox "Product in available" (0/1)
29.11.2021, 13:04
Original comment available on version: ru
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Copyright © OneBox 2024
