Linnworks Integration

Dear Forum,

we currently sell on both opencart web site, amazon and ebay, and direct to people when they turn up at the door. Stock control is now a nightmare.

I had look at a number of systems that will allow cross channel integration and the best for me so far seems to be linnworks.

So I have a couple questions
1:- Is anyone else using linnworks or is there any thing better
2:- Linn works needs every product to have a unique sku, which open cart does not have "out of the box" for variants such as T-shirt Small, T-Shirt medium etc. However Options Plus Redux (OpenCart) seems to give me this. Again is any one using this to feed into their cross platform stock system?

Thanks for any feed back

Peter

You will have to contact Linnworks because their out-of-the-box script will not know about options sku's even if you manage to get them implemented in to OpenCart

They may already have a solution for this.

I had the same problem with OSCommerce and Linnworks.

I coded sku's in to the product options (attributes in OSC) but Linnworks had to recode their connector script to be able to update.

This will most likely be the same with OC

My customer has linnworks and opencart and is also using the addon that offers a unique sku for each product option.

I did speak with linnworks tech but there were only interested in chargin me a significant fund to make a script change, so a friend stepped in and came up with this. It has a wrinjle in it but hope to have that ironed out very soon, otherwise it actually does work. (status 15 is processed)

SELECT o.order_id as orderid,
op.order_product_id as orderitemid,
/* CASE WHEN p.sku = '' or p.SKU is null THEN concat('OCP-', p.product_id) ELSE p.sku END as ItemNumber, */
pov.ob_sku as ItemNumber,
op.quantity as Quantity,
(op.price + (op.tax / op.quantity)) as CostPerUnit,
op.name as ItemTitle,
'' as ProductOption,
0 as ItemTaxRate,
0 as DiscountPercent

FROM `order` AS o

INNER JOIN order_product AS op ON op.order_id = o.order_id
INNER JOIN order_option AS oop ON oop.order_id = op.order_id
INNER JOIN product_option_value AS pov ON pov.product_option_value_id = oop.product_option_value_id

WHERE o.order_status_id IN ('15');

Hi,

Very intreasted in this script.

i use opencart and have the options boost install from Q, and all my products have options and then these have their own SKU's.

So will this script allow linnworks to talk to opencarts options?

if so where / how do i implement this?

thanks

sorry for not getting back sooner.

This needs to go into Linnworks itself, I have to refresh my memory on where, once done I will let you know.

Sorry again, I had to leave this project for a while, something else came up, however I will be getting back to this later next week.

from memory the issue that this DB scrpt adjust caused was the tax calculation was all wrong, and made little sense.