Post by pmchardy » Sat Oct 01, 2011 2:19 am

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




Fri May 20, 2011 4:56 am

Post by uksitebuilder » Mon Oct 03, 2011 4:16 pm

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


For Friendly Professional Support - Click Here

User avatar
Guru Member


Thu Jun 09, 2011 11:37 pm
Location - United Kindgom

Post by spottedhaggis » Sun Dec 02, 2012 6:48 am

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.quantity)) as CostPerUnit, 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');

Active Member


Tue Jun 26, 2012 11:20 pm

Post by vik007 » Wed Jun 26, 2013 10:27 pm


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?


New member


Sun Jul 25, 2010 4:03 am

Post by spottedhaggis » Fri Nov 08, 2013 9:10 pm

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.

Active Member


Tue Jun 26, 2012 11:20 pm

Post by spottedhaggis » Thu Apr 17, 2014 8:21 am

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.

Active Member


Tue Jun 26, 2012 11:20 pm
Who is online

Users browsing this forum: No registered users and 3 guests