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');
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
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
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');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
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
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:-)
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:-)
Who is online
Users browsing this forum: No registered users and 15 guests
