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
- Fri Oct 14, 2011 9:59 pm
- Replies 7
- Views 1135
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 1135
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
- Fri Oct 14, 2011 9:26 pm
- Replies 7
- Views 1135
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 1135
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 4513
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 609
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 601
[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 434
Re: [IMPORTANT] 3 PRODUCTS on ROW
have a look at
http://forum.opencart.com/viewtopic.php ... row#p78179
That should be OK
Peter
- Sun Jun 12, 2011 6:50 pm
- Replies 3
- Views 360
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
- Sun Jun 12, 2011 6:47 pm
- Replies 1
- Views 396
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!!
- Sat Jun 11, 2011 11:07 pm
- Replies 1
- Views 294
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 294
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 396
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 822
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 822
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 1508
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 1508
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
- Fri May 20, 2011 5:25 pm
- Replies 11
- Views 8778
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
- Fri May 20, 2011 4:59 am
- Replies 1
- Views 371
Search found 19 matches
