You can export CSV files from so many digital places – bank statements, online stores. your website, and more!!! Once your data is in a CSV, you can import it into a Google Sheet. You can then reference that data using spreadsheet formulas. Or modify that data and import it back into the original software … More FSA Tip #50 How to import a CSV file into a Google sheet
These spreadsheets will let you import/update your products in your Local Line farm store. Local line only accepts XLSX files. That means you can use the sheets to manage your products and then copy paste into a blank sheet and export that new sheet with 1 tab a s an xlsx. This is going to … More FSA Tip #49 How to import your products into Local Line
These spreadsheets will let you import/update your products in your Square farm store. There are a few more steps than last week’s sheets to import items into a Shopify site, but I bet you can handle it! P.S. One really important thing to note is that Square manages products in 2 ways as POS items … More FSA Tip #48 How to import your products into Square
How do you create products in your online farm store? Let’s say you wanted to add 60 new products in your store. Do you add them one by one? Clicking away and typing. Spending long sessions on the computer to get everything in your system. Not necessarily sure what you’ve already entered? Or do you … More FSA Tip #47 How to import your products into Shopify
You need some good SKUs!!! A SKU is a Stock Keeping Unit. It’s a code you can use across all your farm management systems to clearly identify a product. You can use them in your online store your bookkeeping software your spreadsheets anywhere you want Your SKUs should be made up of a Parent SKU … More FSA Tip #33 Use SKUs To Manage Your Farm Store Products
The easiest way to manage a lot of products in your online store is to import them with a CSV file. But that CSV file usually has a ridiculous amount of rows. It can be a hassle to keep them all synced up. The spreadsheet from the Farm Spreadsheet Tip shows you how to manage … More FSA Tip #32 Tools To Create Product CSV Files For Your Online Farm Store
Ahhh, is there anything more beautiful than a well packed CSA share that is labelled with all the contents? No, there is not. (Unless we want to start talking about Radicchio.) Isn’t there anything more irritating than trying to generate clear itemized labels from the CSV file you exported from your online store that has … More FSA Tip #31 Merge A CSV Order Into 1 Row
This one is for all of you who’ve got an online farm store full of order and need to put together a harvest list to fill those orders. In this tip, we’ll see how to … Export your orders from you online store as a CSV. (This one is from Shopify – it would be similar … More FSA Tip #30 From Order CSV To Harvest List
CSV files, CSV files, CSV files! When you start importing and exporting data from online stores or bookkeeping programs, you start to run into CSV files. In this tip, we’ll see … What are the differences between a CSV file and a spreadsheet Why CSV files are a great way to share information How to … More FSA Tip #22 What Is A CSV File?