How to Integrate Your Cost Data Using Google Sheets
If you're looking to import your SKU and COST data into Flashpricer, Google Sheets is a great option. Here's a step-by-step guide to help you get started:
Step 1: Create a New Sheet
- Go to sheets.google.com and create a new sheet. This will serve as the foundation for your data.
Step 2: Add the Columns for SKU and Cost
- Add two columns to your sheet: one for SKU and one for COST. Copy and paste your SKUs and costs into their respective columns.
Step 3: Publish Your Sheet to the Web
- Click on "File" and select "Share" from the dropdown menu. Choose "Publish to web" from the next dropdown menu.
Step 4: Choose Comma Separated Values
- When the dialog box appears, click the dropdown menu that says "Web Page" and select "Comma Separated Values (.csv)."
Step 5: Publish Your Sheet
- Once you've chosen CSV, click on the "Publish" button. This will publish your sheet to the web, and you'll be provided with a URL.
Step 6: Connect Your Integration in Flashpricer
- Navigate to your Flashpricer account and go to the Integrations page. Click on "Connect Integration" and select "Hosted CSV file."
Step 7: Add Your URL
- Name your integration and paste the URL you copied from Google Sheets into the URL field. Click "Create CSV Integration" to save, and you're done!
Note: To ensure accuracy in cost data, any additional cost changes should be updated either in the Google Sheet or on the SKU level within Flashpricer's products page.
Potential Errors:
The CSV file will return an error for the following reasons:
- the file is not accessible
- file is not a valid CSV
By following these simple steps, you can easily integrate your cost data into Flashpricer!