Search found 19 matches

Page 1 of 1

Search found 19 matches

Re: Automatically filling in product variant skus

OK I have just backed up the database and now I will give the following code a try


UPDATE ocproduct_option_value SET sku = CONCAT(sku FROM ocproduct , ' ', name FROM product_option_value_description);



that throws a syntax error

Jump to post
  • Fri Oct 14, 2011 9:59 pm
  • Replies 7
  • Views 844
Re: Automatically filling in product variant skus

it does, when I change the quantity in linnworks then hit synchronise linnworks has updated the quantity of the variant in my opencart store, so I am happy that lin works is able to associated the opencart product variant where a matching sku exists. But if no sku exists then it is not able to match...

Jump to post
  • Fri Oct 14, 2011 9:38 pm
  • Replies 7
  • Views 844
Re: Automatically filling in product variant skus

the linn works side is fine, when I manually update the product variant skus, but i was hoping for a sql wizard to guide me through a script to do this. I just did not want to have to manually fill in over 2500 skus, that would make me grumpy

Peter

Jump to post
  • Fri Oct 14, 2011 9:26 pm
  • Replies 7
  • Views 844
Automatically filling in product variant skus

Dear Forum, I am integrating Linnworks with my opencart store. All is going well. However, every product and variant needs to have a unique sku. So I installed optionsplusredux. This then gives every variant a filed for a unique sku. However after installing the unique skus are empty. I am looking f...

Jump to post
  • Fri Oct 14, 2011 9:17 pm
  • Replies 7
  • Views 844
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 co...

Jump to post
  • Sat Oct 01, 2011 2:19 am
  • Replies 5
  • Views 4118
Main frame not showing properly with ie 9 opencart 1.4.9.5

I am having a problem with the layout of the main frame. all the images for products and categories are appearing at the bottom of the page and not underneath the top banner. I am using Homepage slideshow by Readyman 1.4.8 www.alreadymade.com. I have tried with this enabled and disabled and it seems...

Jump to post
  • Tue Aug 23, 2011 5:03 am
  • Replies 1
  • Views 525
1.4.9 Why do order numbers not run in order

We see order numbers running in order then missing a few. Am I right in thinking that this is orders that fail at payment stage? I was looking for a way to track abandoned baskets So how many people put item into basket, how many people go to payment and then I know how many orders I have Thanks Peter

Jump to post
  • Wed Jun 15, 2011 10:56 pm
  • Replies 3
  • Views 472
[4.9.1] Out of Stock Message

This is more a question regarding what other users do. I have products with variants such as tee shirt red, green or blue. I Have inventory control turned on. the problem is that if I have 2 red, 2 green and 0 blue then open cart shows the parent product as being out of stock. What I would ideally l...

Jump to post
  • Mon Jun 13, 2011 7:53 pm
  • Replies 1
  • Views 337
Re: Solved [1.4.9] google base feed error

I had the character & in some of the product title and skus. when I replaced & with and the feed worked fine.


Peter

Jump to post
  • Sun Jun 12, 2011 6:47 pm
  • Replies 1
  • Views 353
Solved Re: unwanted text in customer details

when I had been setting up the countries I had entered the following text in the address format of the countries

First Name = {firstname}
and so on

I knew it would be something simple!!

Jump to post
  • Sat Jun 11, 2011 11:07 pm
  • Replies 1
  • Views 217
Solved:-unwanted text in customer details

I am sure I must be missing the blindingly obvious. I have had a look through the forums but I think I must be searching for the wrong words. when a customer places a pay pal order all is fine.However when A customer places a credit card order the customers details always appear as follows ( details...

Jump to post
  • Sat Jun 11, 2011 4:54 am
  • Replies 1
  • Views 217
Solved [1.4.9] google base feed error

I have a 1.4.9 store with multi stores enabled. I have enabled the google feed and set up my google base account. The google feed is being uploaded and parsed. I have about 500 items on my store but google only processes 44 and then only imports 43. When I look at the error report in google it tells...

Jump to post
  • Mon Jun 06, 2011 2:54 am
  • Replies 1
  • Views 353
Re: htaccess not redirecting old url

Thanks for the reply, still not working in the .htaccess I have added RewriteCond %{HTTP_HOST} ^adventurebaby\.co.uk$ [NC] RewriteCond %{REQUEST_URI} !^http://www.adventurebaby.co.uk\/?.*$ RewriteRule ^(.*)$ http://www.adventurebaby.co.uk/$1 [R=301,L] when I go to http://www.adventurebaby.co.uk/bush...

Jump to post
  • Sat Jun 04, 2011 2:20 am
  • Replies 3
  • Views 596
htaccess not redirecting old url

I have enabled multi store in open cart I have added RewriteCond %{HTTP_HOST} ^adventurebaby\.co.uk$ [NC] RewriteRule ^(.*)$ http://www.adventurebaby.co.uk/$1 [R=301,L] to the htaccess file so that adventurebaby maps to the correct store and not the default store I am moving from an erol store and w...

Jump to post
  • Fri Jun 03, 2011 4:41 am
  • Replies 3
  • Views 596
Re: Setting zone_id to a fixed value

when I remove all zones from the country Scotland, the region box still appears with the requirement to choose something which is --none--

Jump to post
  • Sat May 21, 2011 8:15 pm
  • Replies 3
  • Views 1271
Setting zone_id to a fixed value

I am wondering if anyone can help point me to where I am going wrong? I do not want the Region / State (zone) prompt to appear in the guest checkout page. I am happy to have all the zones set as scotland I have a zone set as scotland so I edited the guest_step_1.pl file I removed the portion of code...

Jump to post
  • Sat May 21, 2011 7:23 pm
  • Replies 3
  • Views 1271
Re: Removal of zones (in sweden)

Thanks for the above post. I would like to do this for all countries not just one, is this possible?


Thanks


Peter

Jump to post
  • Fri May 20, 2011 5:25 pm
  • Replies 11
  • Views 7706
hide company box during checkout

I am trying to tidy up the checkout page and as we sell to consumers not businesses I would like to remove the company box from the checkout page. Is this possible?


Thanks

Peter

Jump to post
  • Fri May 20, 2011 4:59 am
  • Replies 1
  • Views 281

Page 1 of 1

Search found 19 matches