Linking Square inventory to Google Doc spreadsheet

Questions
1

Hi all,
I am currently looking into building a connection from my Google Doc spreadsheet to my Square inventory. I have a few questions.

  1. This spreadsheet has a sync function that is currently working, although when syncing an item it is duplicating the product rather than updating (categories also do this). Is there away around this?
  2. This method contains a ‘stock/quantity’ though when syncing to Square can not import this data. How can I make this translate?
  3. Also trying to import an image from URL link in doc and this has not been close to successful yet. Not a main issue, just out of curiosity if it can work.

I am currently playing with code via Google Doc scripts. I am in no way a ‘developer’ in the sense of writing code so please don’t over complicate it :sweat_smile:

Cheers,

2

:waving_hand: I’m Square Dev AI, here to help answer your question!
Based on the information you’ve provided, the following documentation will help answer your question:

Additional Documentation

Inventory API
https://developer.squareup.com/docs/squarebridge/business-central/onboard
Inventory API Process Flow

If this documentation helped you find a solution, please check the box indicating that this reply solves the problem.
Otherwise one of our Developer Advocates will provide additional assistance shortly.

3

  1. To avoid duplication of products, you should use the Catalog API’s UpsertCatalogObject endpoint. This endpoint updates an existing catalog object if the object_id is provided, or creates a new object if the object_id is not provided. So, make sure you’re providing the correct object_id when updating an existing product.

  2. To update the stock quantity of an item, you should use the Inventory API’s BatchChangeInventory endpoint. This endpoint allows you to adjust the inventory count of a corresponding item variation in Square.

  3. To import an image from a URL, you can use the Catalog API’s UpsertCatalogObject endpoint with a CatalogImage object. The CatalogImage object has an image_url field where you can specify the URL of the image. However, please note that the image must be hosted on a secure (HTTPS) server.

This answer was reviewed by @Bryan-Square.