Inventory Sync: Google Drive URL Format

Ablestar Bulk Product Editor allows you to use Inventory Sync jobs to periodically synchronize data between different suppliers or product feeds and your store. Inventory Sync simplifies the process of updating your store's product inventory by retrieving spreadsheet files from various sources.

The Inventory Sync function can download a spreadsheet from a remote server using the following formats to update product data in your Shopify store:

• Dropbox
• Google Drive
• FTP
• Web URL

You can also configure the job to run on a custom schedule.

This feature is only available on Advanced and Professional plans.

Sharing a Google File

When sharing a specific CSV or Excel file from Google Drive, you can obtain a URL to provide to Inventory Sync. This URL allows the app to download the file and update your product inventory.

Important Notes:

• Choose the appropriate sharing permissions, such as "Anyone with the link can view"
• The Google Sheets URL must contain data. Uploading a URL that leads to an empty spreadsheet will result in an error.

Sharing a Folder

Sharing an entire folder in Google Drive provides a more reliable approach for the Inventory Sync process.

By sharing a folder and providing the folder's URL to Inventory Sync, the app will automatically identify and download the most recent file within that folder. This method ensures that your product inventory is updated with the latest data.

Optional: Filtering Files

To further refine the synchronization process, you can filter the files within the shared folder based on specific criteria.

By appending the pound sign (#) followed by a string that matches the desired file name pattern to the folder URL, Inventory Sync will download only the files that meet your specified criteria. For instance, you can filter for specific file types such as CSV files by using "#*.csv".

Shared File URL format:

https://drive.google.com/file/d/15075h-AQCbUxCMBEBEDS@h_wjHM7Zhl/view?usp=sharing 

Shared Folder (with filtering)

https://drive.google.com/drive/folders/3wpT4wrWG3v2xy61s4nL6pcbjMHjhMh3E?usp=sharing#*.csv  

Upload the URL

Once you have the URL prepped, you can upload from our 'Spreadsheet edit' view:

1. Paste URL into the URL field
2. Click the Upload button, and continue to the mapping section
3. Click the Inventory sync button that appears
4. Configure schedule

Click to read more detail about the Inventory Sync process.

✅ Tips and Troubleshooting

• The Google Sheets URL must contain data. Uploading a URL that leads to an empty spreadsheet will result in an error.
• All URLs must be publicly viewable. If the URL requires permission or access restrictions, our app won't be able to retrieve the data.

(06.202)