Forums / General Questions / Translating my mysql data to zen schema

Translating my mysql data to zen schema

Locked

Views: 1,125

Results 1 to 1 of 1
This thread is locked. New replies are disabled.
14 Dec 2009, 3:18 PM
#1
bihon avatar

bihon

New Zenner

Join Date:
Dec 2009
Posts:
8
Plugin Contributions:
0

Translating my mysql data to zen schema

Hello,

I want to make my products properly insterted into zen-cart database schema, thus to put the following data into appropriate fields:

  • Four category levels (Main, sub1, sub2, sub3)
    -Product Code
    -General description
    -Short description
    -Long description
    -Price 1, price 2, price 3 (based on different quantities q1,q2,q3)
    -Picture
    -Stock count
    -Product Group (product can be in different groups)
    -Barcode
    -Dimensions & weight

I have found the general info about the Zen mysql schema here: http://www.zen-cart.com/wiki/index.php/Developers_-_Database_Schema
While some fields are obvious, some others are not and of course, I would like to populate db in such a way that Zen-cart remains fully functional.
Any help?