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.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Why? What are you trying to achieve?phat64mower wrote: ↑Tue May 18, 2021 6:49 pmI would like to replicate the same extraction but using PHPMYADMIN.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
We have too many products and export/import timing out.
Thanks
paulfeakins wrote: ↑Tue May 18, 2021 7:24 pmWhy? What are you trying to achieve?phat64mower wrote: ↑Tue May 18, 2021 6:49 pmI would like to replicate the same extraction but using PHPMYADMIN.
Show version: you can't.phat64mower wrote: ↑Tue May 18, 2021 6:49 pmI would like to replicate the same extraction but using PHPMYADMIN.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
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 pmShow version: you can't.phat64mower wrote: ↑Tue May 18, 2021 6:49 pmI would like to replicate the same extraction but using PHPMYADMIN.
You can dump products with their options and attributes, but not as tabbed document, only as separate files.phat64mower wrote: ↑Tue May 18, 2021 7:39 pmI have extracted products before using PHPMYADMIN just cant remember how.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
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
Increase the PHP timeout value.phat64mower wrote: ↑Tue May 18, 2021 7:27 pmWe have too many products and export/import timing out.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Users browsing this forum: No registered users and 323 guests