Behind the Scenes: Using Google Spreadsheets to create a CSV data feed

So I have a few stores online stores and places to buy stuff on demand from various companies which create and our Jiggy Shop stuff.
From T-shirts, to bags and camera gear, there’s quite a bit in Our Jiggy Creationz Shop. So there are some systems like, our Instagram Shop which allow you to tag products and items from your shop, in the site.

So let’s look at the how to host your data feed on Google Docs. For this post, I will assume you already have a Google account. If not, you will be prompted to set one up once you go into Google Docs.

What is a CSV data feed?

CSV (Comma-Serperated Values / Variables) is a file format where you can make a list of things, which are separated by (guess what) commas. A CSV data feed uses a file save in this format to feed (send) information to another system. In this post, the system we will feed data to is Facebook Business, which then feeds to Instagram shop.

Why do I need one?

Well if you want to be able to manage, your shop links on the go, you should consider this option because once it’s set up, I can be a massive time saver. By using Google Spreadsheets to host your csv, you can update it anywhere (as long as you have internet access on your phone, laptop or desktop, and haven’t locked yourself out of your account!).

Great! Where do I go to get one?

Head of over to Google Spreadsheets and log in. That’s pretty much it. You can then create your csv file.

How do I create my own feed?

Different Systems have different needs when you create the CSV. For Instagram Shop / Facebook Business Catalogue you can download the template

Read More

GDP(er)R ?

What GDPR Means for Creative Industries





In the UK, many of us have heard of the Data  Protection Act 1998, but have you heard of GDRP? Nope?… Neither had I until 2 weeks ago!!

So What Is GDPR? 

Well I’m no expert but, General Data Protection Regulation (GDPR) is an important piece of EU legislation which comes into force on the 25th May2018 and will effect us a consumers and business owners. It will override the current UK Data Protection Act 1998 and will still apply regardless of Brexit, as it regards the data of Eurporean Union individuals regardless of where they live in the world.

A UK Data Protection bill has also been put forward which going forward will become the new Data Protection Act. This will in theory fill in any blanks or clarify anything which has been left open by the GDPR.

How will this Effect Creative Businesses?

As long as you hold data personal data on clients, this will effect your business, So it’s important that you prepare for this change to avoid any on the heavy penalties which you may incur if you fail to look after the data, and ultimately comply with the regulations.

This is essentially a heads up for those of us who are just hearing about this.

Do you feel you are prepared or were you even aware of this change? Feel free to add your thoughts in the comments.

 

For More Information:

 

Read More