Spreadsheet to sql asi sale
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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