Post by vik007 » Tue Jul 23, 2013 2:43 am

Hi,

I am using options boost so all my products have their own SKU.

I am then trying to integrate a software called linnworks with options boost.

At the moment linnworks is NOT picking up the individual SKU's... how can i get linnworks to import the individual skus that option boost holds?

currently the coding in linnworks to bring sku's is:

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,
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` o
INNER JOIN order_product op ON op.order_id = o.order_id
INNER JOIN product p ON p.product_id = op.product_id
WHERE o.order_status_id IN ('1','2');

New member

Posts

Joined
Sun Jul 25, 2010 4:03 am

Post by spottedhaggis » Sat May 10, 2014 6:47 pm

Hi vik007, did you get anywhere with this

I have just picked it back up and working on it again now, so far I still have the following script, but I get the error message below. Bold are the additional statements added to the core linnworks script itself

Code: Select all

SELECT 
	o.order_id as orderid,
	op.order_product_id as orderitemid,
        [b]pov .ob_sku as ItemNumber,[/b]
	CASE WHEN p.sku = '' or p.SKU is null THEN concat('OCP-', p.product_id) ELSE p.sku END as ItemNumber,
	op.quantity as Quantity,
	(op.price + (op.tax / op.quantity)) as CostPerUnit,
	op.name as ItemTitle,
	'test' as ProductOption,
	0 as ItemTaxRate,
	0 as DiscountPercent
FROM `order` o
INNER JOIN order_product op ON op.order_id = o.order_id
INNER JOIN product p ON p.product_id = op.product_id
[b]INNER JOIN product_option_value pov ON pov .product_option_value_id = pov .product_option_value_id[/b]
WHERE o.order_status_id IN ('1');
The error received is

Where o.order_status_id IN ('1'); Error: Response could not be converted fatal query error the server.Root element is missing. Possible cause: Query Syntax is invalid

Active Member

Posts

Joined
Tue Jun 26, 2012 11:20 pm

Post by vik007 » Sat May 10, 2014 6:59 pm

Hi,

after months and months of testing i decided to move to magento...best move by far!

New member

Posts

Joined
Sun Jul 25, 2010 4:03 am

Post by spottedhaggis » Sat May 10, 2014 7:45 pm

I have looked at Magento many many times, but its far too complicated to configure, and modify, as far as I am concerned it is one of the few that are truly terrible, just my opinion

Active Member

Posts

Joined
Tue Jun 26, 2012 11:20 pm

Post by vik007 » Sat May 10, 2014 8:02 pm

yeah i guess everyone entitled to their own opinion. i did try magento previously and i hated it and was far too complicated as you say...so i stuck with opencart..

but after using linnworks i had no option but to bite the bullet and learn magento. it is hard but once setup its great.

The backend or opencart wins hands down! it is very user friendly and easy to use.

Im sure opencart will be able to do exackly the same, but i couldnt get it to.

all the best:-)

New member

Posts

Joined
Sun Jul 25, 2010 4:03 am
Who is online

Users browsing this forum: No registered users and 18 guests