Re: Opencart 3.0 integrate with 3rd party software for inventory update
Hello Sir, I would like to integrate my opencart 3.0 with one of the 3rd party web based software (gartman.com) with the help of API so that any inventory update should reflect directly on opencart and vice versa Opencart stock and processed order should directly reflect on 3rd party inventory soft...
Jump to post- Installation, Upgrade, & Config Support
- Opencart 3.0 integrate with 3rd party software for inventory update
- Mon Jun 10, 2019 4:59 am
- Replies 2
- Views 327
Re: Bridging gap between OC 1.5.6.4 and 3.0.x
You also might find some good Information here: https://webocreation.com/blog/opencart-tutorial/ Good Luck! ;) Ernie Perfect, thank you. I now have enough good reading material to keep me busy to see if I can get up to speed on 3.x. Thank you again, and to everyone else who provided good input. Mike
Jump to post- Mon Jun 10, 2019 4:42 am
- Replies 12
- Views 318
Re: Bridging gap between OC 1.5.6.4 and 3.0.x
There is more to my post then TWIG too. And it's only a very few, left from the OC heydays, where lots of Fans existed too. But the 'global mentality' has changed, all over the place, not only around here, because the World is shrinking into a 'local' Marketplace faster than ever before. Good Luck!...
Jump to post- Fri Jun 07, 2019 8:10 pm
- Replies 12
- Views 318
Re: Bridging gap between OC 1.5.6.4 and 3.0.x
rpmb, You are awesome and thank you for the reply. I will look the links over; I appreciate them. I have the latest OC installed on my server and have all my orders, products, and customer info in it too... the conversion went very well with only one issue that was covered in the forum already and g...
Jump to post- Fri Jun 07, 2019 8:00 pm
- Replies 12
- Views 318
Re: Bridging gap between OC 1.5.6.4 and 3.0.x
Understood and I am doing that but any further suggestions would be helpful. There is more to my post then TWIG too. First of all, you should understand, that nobody will waste his time teaching you OpenCart for free. So start digging into tutorials, read the code and learn everything by yourself. ...
Jump to post- Fri Jun 07, 2019 7:52 pm
- Replies 12
- Views 318
Re: Configure OpenCart with 2 Stores and 2 Domain Names
Make sure you have the / at the end of the store url under admin / settings.
Also you may get some good info from this: viewtopic.php?t=27538
Mike
- Fri Jun 07, 2019 10:42 am
- Replies 2
- Views 233
Re: Bridging gap between OC 1.5.6.4 and 3.0.x
Understood and I am doing that but any further suggestions would be helpful.
There is more to my post then TWIG too.
Mike Jump to post
- Fri Jun 07, 2019 10:34 am
- Replies 12
- Views 318
Re: Bridging gap between OC 1.5.6.4 and 3.0.x
We'd be happy to have a look, it might be that you can make 1.5.6 work with PHP 7 without too many changes. Also have you seen this? https://stackoverflow.com/questions/47178389/converting-opencart-tpl-into-twig That is a nice offer but I would like to learn the differences as I do not wish to have...
Jump to post- Fri Jun 07, 2019 5:34 am
- Replies 12
- Views 318
Bridging gap between OC 1.5.6.4 and 3.0.x
Hello, While I am very happy with 1.5.6.4 time keeps on marching and with PHP V7.x being pressed into a lot of web hosting I have started to look into OC 3.x. There are a lot of changes from TWIG, OCMod, and events. Is there anywhere that does a bridge of knowledge for .tpl to .twig? Also the same f...
Jump to post- Thu Jun 06, 2019 10:59 am
- Replies 12
- Views 318
Re: Opencart 1.5.6.4 with PHP 7.1
By validate, do you mean validate it is set? i.e. isset ? Correct. Also why was it working prior to the update to php 7.1? Industrial change. Which is why, troubleshooting is important so not to stick on same OC version for several years. Thank you for the replies... And there brings up the issue.....
Jump to post- Sun Jun 02, 2019 10:12 am
- Replies 6
- Views 265
Re: Opencart 1.5.6.4 with PHP 7.1
You still need to validate the $this->request->post['email'] prior to pass its super global parameter from the browser into the model. Otherwise, the validate() method may loose its focus since the login page may rely on a last entry point of location on the store-front where the email parameter ma...
Jump to post- Sun Jun 02, 2019 8:59 am
- Replies 6
- Views 265
Opencart 1.5.6.4 with PHP 7.1
Hello, My update to php 7.1 went fine with only one contrib that I see that kicks an error BUT still seems to function. It is for multi-store and prevents people from logging in using accounts from different stores to log into other stores.... In controller/account/login.php I added under protected ...
Jump to post- Sat Jun 01, 2019 11:55 pm
- Replies 6
- Views 265
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- General Support
- Sql query: get option_value_id ONLY if the "name" field matches option_value_description
- Mon Feb 25, 2019 2:20 am
- Replies 22
- Views 1304
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- General Support
- Sql query: get option_value_id ONLY if the "name" field matches option_value_description
- Sun Feb 24, 2019 10:09 pm
- Replies 22
- Views 1304
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- General Support
- Sql query: get option_value_id ONLY if the "name" field matches option_value_description
- Sun Feb 24, 2019 9:26 pm
- Replies 22
- Views 1304
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- General Support
- Sql query: get option_value_id ONLY if the "name" field matches option_value_description
- Sun Feb 24, 2019 12:55 pm
- Replies 22
- Views 1304
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- General Support
- Sql query: get option_value_id ONLY if the "name" field matches option_value_description
- Sat Feb 23, 2019 3:15 am
- Replies 22
- Views 1304
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- General Support
- Sql query: get option_value_id ONLY if the "name" field matches option_value_description
- Wed Feb 20, 2019 7:33 am
- Replies 22
- Views 1304
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- General Support
- Sql query: get option_value_id ONLY if the "name" field matches option_value_description
- Fri Feb 15, 2019 4:15 am
- Replies 22
- Views 1304
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- General Support
- Sql query: get option_value_id ONLY if the "name" field matches option_value_description
- Fri Feb 15, 2019 1:02 am
- Replies 22
- Views 1304
