> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.syncspider.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How to use Google Sheets as a Datahub

Export everything from a system that needs to receive data (stock updates and so on).

![](https://storage.crisp.chat/users/helpdesk/website/-/3/6/b/2/36b28f5921b3fa00/2eee0dd5-1d33-4086-a038-7b6e78_iagf0w.png)

If we wanted to **update stock in WooCommerce**, we would **first export the products from a Google sheet.**

It is recommended for the **sheet** to contain **ID/SKU, Name, Quantity, and Price, at minimum.**

So why not directly map with Magento?

By using this method you can **place additional filters** or adjust some field in WooCommerce where SKU from Magento is kept, **allowing both platforms to match their products.**

e.g. Storing Mag SKU in WooCom custom field, match can be done by this.

This is achieved by selecting **"Update or Create using UID"** as Export behavior, and selecting **SKU or similar as UID**.

![](https://storage.crisp.chat/users/helpdesk/website/-/9/3/7/e/937e37151c401800/7a6242ed-9b2f-4a9a-aec0-12e6d2_x6e92n.png)

**Create or Update** will **update matching products** across both platforms(WooCommerce and sheet) **and create new products** if there is no corresponding UID in target integration.  
There are also **options** to **only update** or **only create products**.

![](https://storage.crisp.chat/users/helpdesk/website/-/d/4/6/a/d46adb33d3a14000/7afbf7b5-5d64-41a3-a9f8-2b36a6_1h6phxj.png)

![](https://storage.crisp.chat/users/helpdesk/website/-/9/2/f/6/92f6e480e094e800/be005109-18f5-4f26-9ba9-401f31_h9xcyw.png)

iz magenta u sheet

+sku od custom fielda

If an update were to come from the source, it would apply it to both WooCommerce's and Magento's products, as they share the SKU, which is our unique identifier.

![](https://storage.crisp.chat/users/helpdesk/website/-/8/8/5/8/88587eb4dcdd9000/e1c0ccee-26ad-4917-bf10-9d734f_ldrh4s.png)

![](https://storage.crisp.chat/users/helpdesk/website/-/c/5/d/3/c5d342a30ccb0000/37bc9232-eafa-43b0-9aa0-f57c07_b57fcj.png)

This type of filter is applicable to multiple fields (sheet columns) at once.

Currently, there is only "equals" filter, but more kinds of filters (such as is set, less than, etc.), much like those for source data, are planned.