Knowledgebase
Trading Software > Help Desk > Knowledgebase

Search help:


Extract OpenCart Data

Solution

MySQL Stored Procedure for extracting product data, 2 levels of categorization and transformed attributes from OpenCart Versions 1.X and V2

 

Licence to use the attached stored procedure

The attached stored procedure is provided 'as is' with absolutely no guarantee or warrantee as to its suitability to do anything. So, use it at your own risk.

If you do use it, please email us to let us know. We'd like to know we've helped someone.

 

Application

  • Download the attached Stored Procedure to your hard drive
  • rename it by removing the .txt extension

 

Use it as a stored procedure in your database

  • open the file in your favorite MySQL client and compile it into the database you want to query
  • Call the procedure using this query: CALL tsl_extract_products_and_attributes()

 

Or .. Extract the relevant query statements and run them in your query window

 

Attachments:
sp_ocv2_extractprods.sql.txt sp_ocv2_extractprods.sql.txt

 
Was this article helpful? yes / no
Related articles Can I manipulate my attribute values
Update OpenCart Stock
Returns Upgrade Ticket 432
Wordpress TSL Objects: sp_process_image_links_start_from_scratch
Article details
Article ID: 74
Category: OpenCart V2
Rating (Votes): Article rated 3.2/5.0 (27)

 
« Go back

 
Powered by Help Desk Software HESK, in partnership with SysAid Technologies