Creating Shopify Database - Please help

[PhilCarson]

I don't know if anyone here uses it, but Shopify's ecommerce reports and database features are rudimentary, at best.

Being an almost complete novice to Access, I would appreciate any help with being able to import my Shopify data into an Access database. I mean, Shopify doesn't even have a field for product cost (to me).
I can export csv data individually for products, customers, and current and historic orders.

I've attached a "Products" export that has both the original csv export and the "save as" Excel version, in case this helps...



Thanks in advance,
Phil

[clapcreative]

You can actually store custom data using Metafields, but you can't change the Shopify database. With Metafields you can store additional information in a number of Shopify resources (for example Product, Blog and Page). Basically Metafields are a key-value store attached to a resource.

You can access the Metafields in the templates using liquid and you can get and set those Metafields using the API.

So to give a short example, you could create a Metafield "favorite_color" attached to the Shop resource. This Metafield will be accessible in all templates using the liquid {{ shop.metafields.NAMESPACE.favorite_color }} (the same NAMESPACE you used when creating the Metafield).
Using Metafields is the only way to store custom data in the Shopify database. If your App needs to store more information (multiple objects with relations in between), you should create your own database. But you probably need to create and run your own database anyway, because you often want to store the authentication credentials for the shop who installed your App.