Tips and Tricks

Tip

Locked

google sheets

By jamnes.rydu ·
Tags: Google
Hi all, I am currently working on some CSV files for sale product upload. What i need to do is to add all the purchase products from one website on to a CSV file on google sheets, which will then be uploaded on to WordPress. Does anyone have any tips on how to do this in bulk rather than adding all the products one by one?
If someone could help me with this, that would be great.

Thank you
James

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Google sheets

by deborasumopayroll In reply to google sheets

Google Sheets is an online spreadsheet app that lets users create and format spreadsheets and simultaneously work with other people. Google Sheets isn’t only for consumers: it's used every day by businesses and schools to manage spreadsheet data. With the new Sheets API v4 and Sheets add-ons, that data can be accessed by code as well as users.
Rich integrations with Sheets data
The features that make Google Sheets so successful are available through the Sheets API. With the API, your code can access and update spreadsheets just like any other user. The API lets your apps:
Import, export and format Sheets data
Control conditional formatting
Build and edit charts embedded in a sheet
Configure data validation
Create and update named and protected ranges
Add and adjust filtered views
Create and manipulate pivot tables

Collapse -

Thank you for sharing!

by liollypresto In reply to Google sheets

Great post, a lot of stuff in here i did not know about

Collapse -

google sheets

by talhaaxhar34 In reply to google sheets

Importing products is useful if you switched to Shopify from another platform or if you want to make many changes to your products or inventory.

When importing, Shopify converts the data from the CSV file into products.

Before you begin, make sure you've read the following topics:

Explanation of CSV files
Explanation of the product CSV fields
Guidelines for attaching multiple images

Caution:
Before you start your import, make sure that you have a backup of your product data. Importing a CSV file that has been sorted by a spreadsheet editor such as Microsoft Excel or Numbers might cause your products to be removed from their relevant image links on the CSV, and your product's images will be lost.

Collapse -

Google Sheet

by rashmitabaliyarsingh In reply to google sheets

Google Sheet provides you the most efficient and elegant features that I have ever seen in other spreadsheet options. I am using it and before it, I hadn't use any other app or software for the sheets, and finding it most comfortable and easy for the bulk data and file transferring as well as making the new one.

Collapse -

Sheets

by screwpumpmanufactu In reply to Google Sheet

Google Sheets is a spreadsheet program included as part of the free, web-based Google Docs Editors suite offered by Google. The service also includes Google Docs, Google Slides, Google Drawings, Google Forms, Google Sites, and Google Keep. Google Sheets is available as a web application, mobile app for Android, iOS, Windows, BlackBerry, and as a desktop application on Google's Chrome OS.

Related Discussions

Related Forums