Search found 1210 matches

Search found 1210 matches

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 2113
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 2113
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 2113
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 852
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 852
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 852
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 852
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 331
.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 852
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 343
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 343
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 343
Re: Fatal Error No: 1146 .. Please Help Someone

Do you have a lightning directory?
Did you install something VQMOD maybe, or some other extension at some point in time?
Do you have a copy of your store offline that you can grep through it and see if you can find the lightning contrib?

Jump to post
  • Fri Jul 13, 2018 7:33 am
  • Replies 6
  • Views 812
Re: I made a mistake renaming the httaccess

What did you use to rename it? If, for some reason, it doesn't allow you to rename it using what you used before try your webhost provided "file manager" or the like. Most host based file managers allow you to manipulate files almost in every way.

Jump to post
  • Fri Jul 13, 2018 7:08 am
  • Replies 4
  • Views 225
Re: Specific product stock feed

Still on the hunt for this... I don't know if this is the right place to post but I also don't know what I should expect the cost to be. Any insight for either is appreciated! Or a lead to someone who might be able to get this done.

Thank you,
Mike

Jump to post
  • Sat Jun 23, 2018 2:22 am
  • Replies 2
  • Views 1705
Sales Tax? Ok now that the Supreme court says we must collect tax

How in the world can it work? How can we collect the tax for everywhere that requires it, and at what rate, keep track of what rates to charge AND how do we send that tax to EVERY place that we collected the tax for? I must be missing something because I don't know how I could keep up with all of th...

Jump to post
  • Fri Jun 22, 2018 7:07 pm
  • Replies 3
  • Views 427
Re: Specific product stock feed

Hello,
I am still looking for this to be built. I would think it wouldn't be too tough to program but I know it is above my skills.

Anyone willing to consider building this and giving me a guess at cost?

Thank you,
Mike

Jump to post
  • Wed Jun 13, 2018 5:02 am
  • Replies 2
  • Views 1705
Specific product stock feed

As it always seems to be I have received access to the product feed for product and options but it doesn't conform to an easy solution. It does not include prices at this time either but may later on. So what I am looking for is a way to get this product update feed, through SFTP, and act upon it to...

Jump to post
  • Wed Apr 04, 2018 8:33 am
  • Replies 2
  • Views 1705
Re: Home page URL change

So you have opencart installed in the /shop directory already? or in the root?

Need more info....

Jump to post
  • Fri Oct 07, 2016 7:48 am
  • Replies 2
  • Views 290
Re: Orders

I believe the ipn callback url is set in your paypal account.

Mike

Jump to post
  • Sat Sep 24, 2016 12:31 pm
  • Replies 26
  • Views 2234

Search found 1210 matches