Search found 11 matches

Page 1 of 1

Search found 11 matches

mle

Re: Adding products to cart from external source

So I had to change add() function in catalog/controller/checkout/cart.php for accepting products via get method, and this worked again. I actually made simple vqmod for thís, just to get hands on with it.

Jump to post
  • Fri Jul 26, 2013 4:42 pm
  • Replies 21
  • Views 19390

mle

Re: Adding products to cart from external source

Getting back to old subject, seems that http://www.yourstore.com/index.php?rout ... uct_id=xxx doesn't work anymore. Have to dig what has been changed. If anyone already knows, I would be grateful!

Jump to post
  • Tue Jul 16, 2013 5:25 pm
  • Replies 21
  • Views 19390

mle

Re: Adding products to cart from external source

Yes, I do have such a script, unfortunately I can't directly share it, as a) it's heavily dependent of Customer's internal services (would need lot's of cleanup of those) and b) it's Customer's IPR. Anyway, setup is quite simple. In frontpage, I have text field for search. When user enters product n...

Jump to post
  • Thu Jul 21, 2011 10:01 pm
  • Replies 21
  • Views 19390

mle

Re: Adding products to cart from external source

After night of coding, I finally managed to solve problem. I have javascript which calls php-script. Script checks if product already exists in database, if not, it inserts product there, and then again javascript page is redirected to http://www.yourstore.com/index.php?route=checkout/cart&product_i...

Jump to post
  • Thu Mar 10, 2011 6:02 pm
  • Replies 21
  • Views 19390

mle

Re: Adding products to cart from external source

I wrote a small script which imported all products into OC's db, and it's basicly working quite nicely. Problem is that obviously +500 000 products is too much for my setup, every product search takes ~8 seconds, which is too much. Server itself has quite a lot resources, so I really can't reduce se...

Jump to post
  • Wed Mar 09, 2011 10:40 pm
  • Replies 21
  • Views 19390

mle

Re: Adding products to cart from external source

Perhaps using a MySQL view to the external product table might help? This way Opencart still thinks it uses its product table when in fact it's just a view to the external one. Just a thought. I could try this as well, only thing I would need to know is how to map fields between external db and Ope...

Jump to post
  • Wed Mar 09, 2011 3:50 pm
  • Replies 21
  • Views 19390

mle

Re: Adding products to cart from external source

I'm still a bit lost with this issue. Basically, I have few options: 1. Import all products into OpenCart's product db. 2. Use external db and with some magic, bring products from there to cart 1) would be doable, but there's few questions: - How does OC handle +500 000 products? Those are very simp...

Jump to post
  • Thu Mar 03, 2011 3:52 am
  • Replies 21
  • Views 19390

mle

Re: Database schema diagram?

Does this still exist? I would love to get at least some kind of description how products are in db, would save a lot of reverse engineering :)

Jump to post
  • Fri Feb 25, 2011 8:30 pm
  • Replies 3
  • Views 3984

mle

Re: Adding products to cart from external source

Ok, I wrote a script which did comparisons between tables and products, and populated third table with valid products and prices. Now I gotta investigate db schema, so I can wrote sccript which imports all products into db. There's +500 000 products in table, how does opencart handle this amount, an...

Jump to post
  • Sat Feb 19, 2011 5:25 pm
  • Replies 21
  • Views 19390

mle

Re: Adding products to cart from external source

Yep, they are indeed in external db. There's also currently one thing, items are actually on two tables, and when users are searching products, it will compare which one has lower price... Well, I might need to think of importing all of them into opencart's product db, is there any way to import the...

Jump to post
  • Fri Feb 18, 2011 9:36 pm
  • Replies 21
  • Views 19390

mle

Adding products to cart from external source

I have included external product search in frontpage. It's simple search field, which fetches products from external database (which has +10k products). There's product id and price in results, they are in simple table. It would be extremely nice if users could add these external products to cart, c...

Jump to post
  • Fri Feb 18, 2011 9:05 pm
  • Replies 21
  • Views 19390

Page 1 of 1

Search found 11 matches