Post by phat64mower » Tue May 18, 2021 6:49 pm

Hi Guys,

When I do a "products" extraction using the Export/Import Tool for Opencart I open the file in Excel and file opens up with Tabs:

Products >> AdditionalImages >> Specials >> Discounts >> Rewards >> ProductOptions >> and so on.

I would like to replicate the same extraction but using PHPMYADMIN.

How do I do this?
What tables do I need to export?
What Format do I extract in? CSV? CSV for MS Excel?

Thanks in Advance.

Newbie

Posts

Joined
Fri Jan 09, 2015 9:30 pm

Post by straightlight » Tue May 18, 2021 7:13 pm

Google request.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by paulfeakins » Tue May 18, 2021 7:24 pm

phat64mower wrote:
Tue May 18, 2021 6:49 pm
I would like to replicate the same extraction but using PHPMYADMIN.
Why? What are you trying to achieve?

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by phat64mower » Tue May 18, 2021 7:26 pm

Hi,

I have tried to no avail.

Thanks
straightlight wrote:
Tue May 18, 2021 7:13 pm
Google request.

Newbie

Posts

Joined
Fri Jan 09, 2015 9:30 pm

Post by phat64mower » Tue May 18, 2021 7:27 pm

Hi,

We have too many products and export/import timing out.

Thanks
paulfeakins wrote:
Tue May 18, 2021 7:24 pm
phat64mower wrote:
Tue May 18, 2021 6:49 pm
I would like to replicate the same extraction but using PHPMYADMIN.
Why? What are you trying to achieve?

Newbie

Posts

Joined
Fri Jan 09, 2015 9:30 pm

Post by thekrotek » Tue May 18, 2021 7:36 pm

phat64mower wrote:
Tue May 18, 2021 6:49 pm
I would like to replicate the same extraction but using PHPMYADMIN.
Show version: you can't.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by phat64mower » Tue May 18, 2021 7:39 pm

Hi,

Thanks for your reply.
My version is 3.0.3.1

I have extracted products before using PHPMYADMIN just cant remember how.

Thanks
thekrotek wrote:
Tue May 18, 2021 7:36 pm
phat64mower wrote:
Tue May 18, 2021 6:49 pm
I would like to replicate the same extraction but using PHPMYADMIN.
Show version: you can't.

Newbie

Posts

Joined
Fri Jan 09, 2015 9:30 pm

Post by thekrotek » Tue May 18, 2021 11:06 pm

phat64mower wrote:
Tue May 18, 2021 7:39 pm
I have extracted products before using PHPMYADMIN just cant remember how.
You can dump products with their options and attributes, but not as tabbed document, only as separate files.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by JNeuhoff » Tue May 18, 2021 11:10 pm

Why don't you just export your products in smaller batches, e.g. 5000 at a time, starting with batch number 1, then 2, 3, 4 etc. ?
Or use the categories filter?

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by paulfeakins » Wed May 19, 2021 6:14 pm

phat64mower wrote:
Tue May 18, 2021 7:27 pm
We have too many products and export/import timing out.
Increase the PHP timeout value.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom
Who is online

Users browsing this forum: Semrush [Bot] and 258 guests