Syncing Stock Levels With Linnworks

[chulent]

Hi I am brand new to all this. I am building a website using a CSV file to import all categories and data. I have managed to upload that without difficulties however I am having trouble syncing my stock levels. Everything seems to be fine on the Linnworks side and i was wondering if there is something I have not set up right on presta shop.

 

Thanks in advance for any help.

[Radu]

Note: I have not worked with Linnworks.

 

- when you sell something using presta, how Linnworks knows to substract the stock?

- if you modify something to Linnworks how you notify presta?

[chulent]

Hi Radu

 

Thanks for replying.

 

Linnworks syncs automatically with presta shop and downloads all orders etc. This is all working fine I.e when I get an order it syncs with linnworks and thats fine. Its the stock levels which don't seem to be working.

[dreamworks2050]

Im having the exact same problem, levels not being pushed from Linnworks to Prestashop. Any solution?

[electrical-store]

Hi

 

Go to settings>chanel intergration>config>query designer>edit update inventory> and then paste the following into tags:

 

 

UPDATE

`ps_stock_available` AS sa

INNER JOIN `ps_product` AS p on p.id_product = sa.id_product

SET

sa.quantity = CONVERT('[{NewQuantity}]', signed integer),

p.quantity = CONVERT('[{NewQuantity}]', signed integer)

WHERE p.reference = '[{ChannelSKU}]'

--GO;--

UPDATE ps_product_attribute

SET

quantity = CONVERT('[{NewQuantity}]', signed integer)

WHERE reference = '[{ChannelSKU}]';

 

That should do it.