Uses etsy api to generate a csv in the required data feed file format for integration with facebook/instagram webshops. The facebook csv template can be found here. Only the required columns + the extra images are implemented although the code could easily be explanded to include more columns.
For use an etsi api key must be stored in a txt document "api_key.txt" in the root directory. For also using the automatic backup to dropbox (which can then be linked to facebook catalogue data feed) a valid dropbox api token is also needed, should be stored in "dropbox_token.txt" in root.
A useful guide for the general process is this.
The "etsy_csv_getter.py" script can be run directly, the following variables are needed:
- etsystore : name of shop as it appears on etsy
- brandname: name of brand as it should appear on facebook, often same as etsystore
- sku_base: base for id on facebook catalogue, if not inputted will default to etsy sku
If also using dropbox:
Configure the "BACKUP" path, where the csv will be uploaded to, is relative to folder of dropbox app connected to the given token. The default is the root directory. When giving the link to the csv on dropbox to the catalogue manager, set "dl=1" at the end of the link!
For ease of use this can be packaged into a single script with a simple interface and then made into an executable, "fully_automated.py" is what I am using.
The dropbox saving script is not my code, taken from here.