Spreadsheet to sql asi sale

2018-07-20 Friday

Notes on terms of this article:

• spreadsheet columns are analogous to relational database fields,
• product or item attributes map to (get stored in) database fields,

ASI plant sale 2018 has plants listed in a spreadsheet with the following fields (columns):

  price, name, description, image_filename, quantity

These item attributes map to Opencart table columns (fields) in the table oc_product and oc_product_description:

         price --> oc_product.price
          name --> oc_product_description.name
   description --> oc_product_description.description
image_filename --> oc_product.image
      quantity --> oc_product.quantity