Skip to content

Instantly share code, notes, and snippets.

@qcom
Created January 16, 2013 19:39
Show Gist options
  • Save qcom/4550133 to your computer and use it in GitHub Desktop.
Save qcom/4550133 to your computer and use it in GitHub Desktop.
I use excel to generate product upload files for Google's Merchant Center, Amazon's Seller Central, and in-house e-commerce solutions.
But it's the same type of data (i.e. products), and sometimes even the same data, just being pushed to different targets.
Maintaining these often half-duplicate xlsx files has become tedious and unwieldy, so I'm wondering if I should have a database of products that would allow me to generate a spreadsheet for each target (by performing certain queries on my more general data I'd assume).
Is this a legitimate time to use a database?
And, if so, should I use a relational database? I'm not too clear as to what kind of data is relational and what kind isn't, but I've read that traditionally relational databases are used in the corporate/e-commerce area.
But that could just be history rather than adeptness.
Anyway, just wondering.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment