> For the complete documentation index, see [llms.txt](https://docs.xorosoft.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.xorosoft.com/xoroerp-1/connected-apps/shopify/product-synchronization-between-xoro-and-shopify/pulling-products-from-shopify-xoro.md).

# Pulling Products From Shopify → Xoro

Products can be pulled from Shopify into Xoro using either of the following methods:

1. **Using Product ID**
2. **Using Regular Expression**
3. **Using Metafield**

### Pulling Products Using Product ID

The **Product ID** method allows you to pull a specific Shopify product into Xoro by using the product's unique ID. Before importing the product, the Shopify sales channel must be configured to enable product pulling and use **Product ID** as the [**Base Part Number Resolution Type**](https://docs.xorosoft.com/xoroerp-1/connected-apps/shopify/installation-guide/configuration-settings/products-and-inventory/products.md).

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2F7ZfrZLEYKW3w4koJ26hA%2Fimage.png?alt=media&amp;token=cdeb66c0-8a59-485d-8c8b-94cdc6721a4d" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2FpKv8KUGMkbSgvTz1cgFR%2Fimage.png?alt=media&amp;token=4219dc81-54d7-4302-bfaf-1940adc9555b" alt=""><figcaption></figcaption></figure>

#### Workflow

**Step 1:** In Shopify, go to **Products** and click **Add product**.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2FeL6KcKYuSfFlZW1eVYzv%2Fimage.png?alt=media&amp;token=cac781fb-2025-493c-afb2-811ac3c1582a" alt=""><figcaption></figcaption></figure>

**Step 2:** Enter the required product information, including the **Title**, **Description**, **Media**, **Category**, **Type**, and **Vendor**. Save the Product.&#x20;

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2FrzgHzRvMFhG45Sxhz42l%2Fimage.png?alt=media&amp;token=8a34e5af-e078-4637-839e-1c83eb1c55aa" alt=""><figcaption></figcaption></figure>

Add the required product options and create the required variants.&#x20;

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2F2TWdxpr7yCtOZvzgAFsm%2Fimage.png?alt=media&amp;token=f249ecd8-6c63-4536-b940-18a47ff15b92" alt=""><figcaption></figcaption></figure>

**Step 3:** Select all the variants and click **Bulk edit**.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2FEqW4w9C30oXecdlYW4Px%2Fimage.png?alt=media&amp;token=f32216ec-9646-40e9-9bd5-79f68e6216de" alt=""><figcaption></figcaption></figure>

**Step 4:** In the bulk editor, enter a unique value in the **SKU** column for each variant.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2F1QAge0Mz9r01hPkRTye2%2Fimage.png?alt=media&amp;token=23d8a339-e83b-4434-a93d-ad260786f7bc" alt=""><figcaption></figcaption></figure>

> **Note:** The SKU is used as the **Item #** when the product is imported into Xoro. A SKU must be specified for every variant. Variants with a blank SKU cannot be successfully imported into Xoro.

**Step 5:** Save the product and copy the **Product ID** from the URL. The Product ID is the number displayed at the end of the product URL.

**Step 6:** In Xoro, go to **Pull SKUs** and select **Actions → Import by product**.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2Fg0HTsMqamhCWRJcMfdA6%2Fimage.png?alt=media&amp;token=a22a98d3-9373-4326-9ab4-dc0064e31236" alt=""><figcaption></figcaption></figure>

**Step 7:** In the **Import products** window, select the **Shopify product id**. Enter the Shopify **Product ID** and click **Import**.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2FYNhBlYMdvLWBsUxz8w2X%2Fimage.png?alt=media&amp;token=8eae5daf-8bd4-4913-9c6d-a14463329733" alt=""><figcaption></figcaption></figure>

**Step 8:** Go to **Logs** and verify the import status. A successful **Sync SKUs (App To Xoro)** entry confirms that the product was successfully imported from Shopify.

**Step 9:** Open **Product Centre** and search for the imported product using its **product id** in **Base Part #** or other product details.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2F089YnpUMZOJv8RyZ459V%2Fimage.png?alt=media&amp;token=a6b0d897-abbe-4e6c-9263-89f4b8e47405" alt=""><figcaption></figcaption></figure>

Right-click the product and click **Show Variants** to verify that the product's variants have been created as corresponding items using the SKU values entered in Shopify.

### Pulling Products Using Regular Expression

Products can be pulled from Shopify to Xoro using a **Regular Expression** to determine the **Base Part Number** from the variant SKU. The regular expression is applied to the variant SKU during the import, and the extracted value is used as the product's **Base Part Number** in Xoro.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2F7ZfrZLEYKW3w4koJ26hA%2Fimage.png?alt=media&amp;token=cdeb66c0-8a59-485d-8c8b-94cdc6721a4d" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2FfBH2gKROCbWRnfNE6YW0%2Fimage.png?alt=media&amp;token=fe408be6-2540-47dd-98a0-46b768d7852a" alt=""><figcaption></figcaption></figure>

### Workflow

**Step 1:** In Shopify, go to **Products** and click **Add product**.

**Step 2:** Enter the required product information, including the **Title**, **Description**, **Media**, **Category**, **Type**, and **Vendor**. Add the required product options and create the required variants. Enter the required prices for the variants and save the product.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2Fhw9WpPXnzIVbHeuSbjfW%2Fimage.png?alt=media&amp;token=b5d13b4d-d9de-42be-a082-1240b7418432" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2Ffv7wid4Jg9YAelLMhTaA%2Fimage.png?alt=media&amp;token=efcb0c3f-dffd-42e7-ba92-55301b47a94a" alt=""><figcaption></figcaption></figure>

**Step 3:** Select all the variants and click **Bulk edit**. In the bulk editor, enter a unique value in the **SKU** column for each variant.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2F1vaFnxZTwadRL75AofLr%2Fimage.png?alt=media&amp;token=833fddb2-7c39-4285-b68b-502548cc37a5" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
The SKU is used as the **Item #** when the product is imported into Xoro. A SKU must be specified for every variant. Variants with a blank SKU cannot be successfully imported into Xoro.
{% endhint %}

**Step 4:** Save the product and copy the **Product ID** from the URL. The Product ID is the number displayed at the end of the product URL.

**Step 5:** In Xoro, configure the product pull settings before importing the product. Enable **Pull products** and set **Base Part Number Resolution Type** to **Regular Expression**. In **Base Part Number Resolution String**, enter the required regular expression.

For example, use:

```
^([^-]+)
```

This expression extracts the portion of the variant SKU before the first hyphen. For example, for the SKU **SLIMNIGHT-RED-L**, **SLIMNIGHT** is extracted and used as the **Base Part Number** in Xoro.

**Step 6:** Now, go to **Pull SKUs** and select **Actions → Import by product**. In the **Import products** window, select **Shopify product id**. Enter the Shopify **Product ID** and click **Import**.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2FNH0tFC9qNdG6S2WKw0fW%2Fimage.png?alt=media&amp;token=69758ecf-521b-491e-8c9d-5887f86b752d" alt=""><figcaption></figcaption></figure>

**Step 7:** Go to **Logs** and verify the import status. A successful **Sync** confirms that the product was successfully imported from Shopify.

**Step 8:** Go to **Product Centre** and search for the imported product using the **Base Part #** generated from the regular expression.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2F3VyPRltln4wktlc3XBFe%2Fimage.png?alt=media&amp;token=c56b3a57-46fe-438b-b373-eb868c91f9f2" alt=""><figcaption></figcaption></figure>

**Step 9:** Right-click the product and click **Show Variants** to verify that the product's variants have been created as corresponding items using the SKU values entered in Shopify.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2Fx8VMJYmyfUTJo3woLlWA%2Fimage.png?alt=media&amp;token=b5306601-856b-421f-a8d0-78616f2be5b2" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2FVpu0jCkKnqIim2Gc9df5%2Fimage.png?alt=media&amp;token=76183d71-d46c-459e-bc2c-fdfc8d75b6a7" alt=""><figcaption></figcaption></figure>

### Pulling Products Using Metafield

Xoro can use a Shopify product metafield to determine the **Base Part Number** when importing a product. This provides a direct field-to-field mapping between Shopify and Xoro: the value entered in the Shopify **Base Part** metafield is used as the **Base Part#** for the corresponding product in Xoro.

#### Workflow

**Step 1:** In Shopify, go to **Products** and open the product you want to import into Xoro.&#x20;

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2Fejo79lbn9b59OpEHBXEX%2Fimage.png?alt=media&amp;token=4bd26513-f6ef-43e2-abfc-1c2eefe2b86f" alt=""><figcaption></figcaption></figure>

**Step 2:** Scroll to the **Product metafields** section and locate the **Base Part** field. Click the **Base Part** field.&#x20;

**Step 3:** The **Metafields and metaobjects** page opens for the **Base Part** metafield. On the **Metafields and metaobjects** page, copy the metafield value displayed for the **Base Part** field.

For example, the metafield value is displayed as: `custom.base_part`

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2FdmAKyJheEo8ODDTSjF4C%2Fimage.png?alt=media&amp;token=06cb85a0-b064-4dd0-b44f-92d25df289b4" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2FwIUFMItYPGtfbLIHzJzL%2Fimage.png?alt=media&amp;token=25996350-63f3-47fc-aa5e-d3ace8fa88fa" alt=""><figcaption></figcaption></figure>

**Step 4:** In Xoro, open the Shopify sales channel settings and set **Base Part Number Resolution Type** to **Metafield**.

**Step 5:** In **Base Part Number Resolution String**, enter the metafield value copied from Shopify.

Replace the `.` with a `,` as required by the setting. For example: `custom.base_part` becomes: `custom,base_part`

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2FFSYacms09Ggfw0oFFU1M%2Fimage.png?alt=media&amp;token=85598117-1980-4d9c-989e-743e1b2e0ab4" alt=""><figcaption></figcaption></figure>

**Step 6:** Return to the Shopify product and, under **Product metafields**, enter the required Base Part value in the **Base Part** field.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2FzFUF9kwpZZsYOCtTFgub%2Fimage.png?alt=media&amp;token=8706b3c1-461e-4e08-a6ae-2b5ff6567c80" alt=""><figcaption></figcaption></figure>

**Step 7:** In Xoro, go to **Pull SKUs** and select **Actions → Import by product**.

**Step 8:** In the **Import products** window, select **Shopify product id**, enter the Shopify **Product ID**, and click **Import**.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2Fj5mQ6DoY4l4mCDQExXRo%2Fimage.png?alt=media&amp;token=f0aeb3d9-c725-4424-b209-09f9e91fd5e8" alt=""><figcaption></figcaption></figure>

**Step 9:** Go to **Logs** and verify the import status. A successful **Sync** confirms that the product was imported from Shopify.

**Step 10:** Go to **Product Centre** and search for the imported product. Verify that **SleekSlims** is displayed as the product's **Base Part#**.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2FGFQRX1Woj5N1vMFsfKWm%2Fimage.png?alt=media&amp;token=32775322-56f3-4f79-81de-68f0e3694201" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.xorosoft.com/xoroerp-1/connected-apps/shopify/product-synchronization-between-xoro-and-shopify/pulling-products-from-shopify-xoro.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
