Search found 1198 matches

Search found 1198 matches

Re: Sql query: get option_value_id ONLY if the "name" field matches option_value_description

I replied I don't know as I use a contrib to make site updates so maybe the option ids are not static. Exactly, you are using an extension. As mentioned on my above post reply, since you're using an extension, contact the extension developer of that extension to see if this can be done. If what can...

Jump to post
  • Mon Feb 25, 2019 2:20 am
  • Replies 22
  • Views 1051
Re: Sql query: get option_value_id ONLY if the "name" field matches option_value_description

If option ids are static, can you not loop through product ids and avoid text field searches? That piece I don't know 100%. I was under the impression using the import/export tool it changes the option ids when you do an import. I'll have to look through the logic again as I looked recently and I s...

Jump to post
  • Sun Feb 24, 2019 10:09 pm
  • Replies 22
  • Views 1051
Re: Sql query: get option_value_id ONLY if the "name" field matches option_value_description

If you're looking to use a custom code from the import / export tool, contact the extension developer to see how this could be done with the multiquery method. This is NOT what I am doing. I use the import export tool in normal upkeep of my site. IF that tool changes the option IDs then it would al...

Jump to post
  • Sun Feb 24, 2019 9:26 pm
  • Replies 22
  • Views 1051
Re: Sql query: get option_value_id ONLY if the "name" field matches option_value_description

If option ids are static, can you not loop through product ids and avoid text field searches? That piece I don't know 100%. I was under the impression using the import/export tool it changes the option ids when you do an import. I'll have to look through the logic again as I looked recently and I s...

Jump to post
  • Sun Feb 24, 2019 12:55 pm
  • Replies 22
  • Views 1051
Re: Sql query: get option_value_id ONLY if the "name" field matches option_value_description

So tell us more about the 18k+ products ... do they all have options? Can they be grouped by the type of options they share? Do these options change every update or are they static - eg product id 100 = always has option_value_ids 1 and 50 ... ? They are actually 18k line items for the file that ca...

Jump to post
  • Sat Feb 23, 2019 3:15 am
  • Replies 22
  • Views 1051
Re: Sql query: get option_value_id ONLY if the "name" field matches option_value_description

G'day Mike - is this following on from this post ? I don't think the angle you're taking here will work, esp with the number of rows you're trying to check. I'd consider some paid help for this, cos it's a script that could be written fairly quickly. Simon G'day Simon, Yes it is, and it completely ...

Jump to post
  • Wed Feb 20, 2019 7:33 am
  • Replies 22
  • Views 1051
Re: Sql query: get option_value_id ONLY if the "name" field matches option_value_description

I have it working right now with foreach loops, and it does work well, but with a file I am acting on having 18000 line items I am concerned that I will have a drag on the server each night as it goes through the update because of the 3 foreach loops going through the arrays for comparison for acti...

Jump to post
  • Fri Feb 15, 2019 4:15 am
  • Replies 22
  • Views 1051
Re: Sql query: get option_value_id ONLY if the "name" field matches option_value_description

What this user seem to be looking for is looking for a portion text from the option_value_description according to what it says on the first post. In order to accomplish this, using the array with implode is not the solution but rather to look inside the description with an SQL function that has a ...

Jump to post
  • Fri Feb 15, 2019 1:02 am
  • Replies 22
  • Views 1051
Re: Sql query: get option_value_id ONLY if the "name" field matches option_value_description

Same, name is array you choose in ex: $optionval = ["Yellow", "Green", "RED"]; SELECT * FROM " . DB_PREFIX . "option_value_description WHERE name IN('". implode( "','" , $optionval )."') query results object(stdClass)[5] public 'row' => array (size=4) 'option_value_id' => string '42' (length=2) 'la...

Jump to post
  • Thu Feb 14, 2019 7:58 pm
  • Replies 22
  • Views 1051
Re: Sql query: get option_value_id ONLY if the "name" field matches option_value_description

if you have $eachoptionvalue is an array, example [1,5,9,12] you can use this query "SELECT name FROM " . DB_PREFIX . "option_value_description WHERE option_value_id IN(". implode( "," , $eachoptionvalue ).")" I feared the question would be a little confusing but I am actually not looking for the n...

Jump to post
  • Thu Feb 14, 2019 12:23 pm
  • Replies 22
  • Views 1051
Sql query: get option_value_id ONLY if the "name" field matches option_value_description

Don't we all love sql queries? :) Ok here is one for you that I am am too novice at sql queries to figure out past what I already have. "SELECT option_value_id FROM " . DB_PREFIX . "product_option_value WHERE product_id = ' " .$productId . " ' AND (option_id = '18' OR option_id = '13')"; This return...

Jump to post
  • Thu Feb 14, 2019 8:57 am
  • Replies 22
  • Views 1051
Re: .csv update of options quantity .... .and secondary question about options in DB option_value

Well the logic works and I am able to do the updates using my wholesaler's feed. I just needed to update a few options as their feed has some options truncated like "blk" where I have them spelled out as "Black" but that is ok, I can adapt for those simple differences. Now I need to work on having t...

Jump to post
  • Tue Feb 12, 2019 6:18 am
  • Replies 8
  • Views 566
Re: .csv update of options quantity .... .and secondary question about options in DB option_value

Thank you very much Simon for the reply. Getting the correlation is where I get lost. I know I can search for the product_id and option_id and I'll get the option_value_ids... (BTW Option_id 18 equals weight in how I have the options configured and unfortunately 18 is also a possibility of the weig...

Jump to post
  • Thu Feb 07, 2019 7:46 am
  • Replies 8
  • Views 566
Re: .csv update of options quantity .... .and secondary question about options in DB option_value

You have tried this extension? https://www.opencart.com/index.php?route=marketplace/extension/info&extension_id=17 Yes and we have been using it since we started to us opencart but it doesn't work as needed for updating product quantity and options from the feed I posted. I need something that I ca...

Jump to post
  • Thu Feb 07, 2019 7:19 am
  • Replies 8
  • Views 566
Re: .csv update of options quantity .... .and secondary question about options in DB option_value

Thank you very much Simon for the reply. Getting the correlation is where I get lost. I know I can search for the product_id and option_id and I'll get the option_value_ids... (BTW Option_id 18 equals weight in how I have the options configured and unfortunately 18 is also a possibility of the weigh...

Jump to post
  • Wed Feb 06, 2019 12:45 pm
  • Replies 8
  • Views 566
Re: Email to admin about new customer

Try going into: catalog/model/account/customer.php finding: $message .= $this->language->get('text_email') . ' ' . $data['email'] . "\n"; and add this above it: $message .= $this->language->get('text_city') . ' ' . $data['city'] . "\n"; You can move that line I have you adding to where you want it b...

Jump to post
  • Tue Feb 05, 2019 7:34 am
  • Replies 2
  • Views 210
.csv update of options quantity .... .and secondary question about options in DB option_value

Hello! It has been a while since I have tried to tackle this and yes I am still using 1.5.6.4. So let's get directly to it. I am now doing a lot more drop shipping versus keeping a huge amount of stock... therefore it isn't my stock levels but my wholesalers stock levels that I need to keep up with....

Jump to post
  • Sun Feb 03, 2019 10:51 pm
  • Replies 8
  • Views 566
Re: Parent child with price changes ... is Opencart still the one to use as I am getting overwhelmed....

Any other people with thoughts on the issue I am running into? How do others handle products, options, prices of the product with options and discounts?

Thank you,
Mike

Jump to post
  • Thu Oct 11, 2018 6:19 am
  • Replies 3
  • Views 304
Re: A note to all 1.5.6.4 Users ...

Well, for v.1.5.6.4, a few misses have still been found and fixed: ;) --- But to your problem, did you already check on this, it might make you work a little easier, but I never tested it yet, so, I cannot judge: https://www.opencartmanager.com --- Ernie I have fixed all and updated all issues with...

Jump to post
  • Sun Oct 07, 2018 9:42 pm
  • Replies 3
  • Views 304
Parent child with price changes ... is Opencart still the one to use as I am getting overwhelmed....

Hi! I have been using opencart for quite a while (but I haven't updated past 1.5.6.4 because of some custom made support programs that I use don't work above that version). It has been an ongoing addition of products but I have reached a point where my little hacks to keep up are not working too wel...

Jump to post
  • Sat Oct 06, 2018 4:28 am
  • Replies 3
  • Views 304

Search found 1198 matches