> ## Documentation Index
> Fetch the complete documentation index at: https://docs.global-e.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Fixed Price Management

## Overview

The **Fixed Price Management** feature lets you manage your local market prices by uploading a file describing the fixed prices for specific products and territories. Note that these prices override Shopify pricelists set via API, ignoring country or currency restrictions. In the past you could only submit new prices to update immediately. Now you can select a date and time for your price submissions to go into effect.

The following figure shows the Fixed Price Management screen:

![](https://mintcdn.com/globale-enterprise/SnRXO1uzDQe-KGkt/images/uuid-542c5fdd-b48c-f72e-50f7-646030fb90e8.png?fit=max\&auto=format\&n=SnRXO1uzDQe-KGkt\&q=85\&s=b7bb90f8041b5332e522f37c3182f465)

## Uploaded File Table

The following figure shows the uploaded file table:

![](https://mintcdn.com/globale-enterprise/12a3ouYsTLkxux6r/images/uuid-732bbda3-d56f-56bf-ed34-5339c3b8ad10.png?fit=max\&auto=format\&n=12a3ouYsTLkxux6r\&q=85\&s=9519587f479f440392e23642c59d3dee)

The table above shows the file, status, submission date, effective date, and user.

## Accessing Fixed Price Management

**To access the Fixed Price Management feature**

1. Navigate to Merchants > Product Management > Fixed Price Management from the top menu.
2. Select a merchant from merchant menu located at the top of the page.

## Setting Up Your Price Sheet

Price sheets you submit must be in CSV format, and you can download a sample CSV format to use as the basis for your submissions by clicking **Download Sample**. The sample file includes an example and explanation of each value. The downloadable sample does not include the product\_id column yet. To upload prices by product, add product\_id as the first column, as shown in the example below.

Price sheets require the following information:

| **Header** | **Description** | **Example** |
| - | - | - |
| product\_id | Enter the Shopify Product ID. If both the variant\_id and sku fields are empty, the price applies to all variants of that product. If the product does not exist in Global-e yet, the row is rejected as an invalid product. Not required if using Variant ID or SKU. | 7982301462687 |
| sku | Enter the Product SKU as it appears in your product catalogue. The SKU may not include spaces.If you are using barcodes instead of SKU, this field must contain the barcode. However, leave the column name as “SKU”. Not required if using Product ID or Variant ID. | AD-01-white-6 |
| variant\_id | Enter the Product Variant ID, as assigned in your product catalogue. Each row must include at least one of the product\_id, sku, or variant\_id fields. Not required if using Product ID or SKU. | 36485954240671 |
| country\_code | Enter the ISO-2 country code to indicate the country relevant to this price.For instance, DE (Germany), US (USA).If this field is empty, the currency\_code field must be populated. | DE |
| currency\_code | Enter the 3-char currency code (ISO-4271) to indicate the currency relevant for this change.For instance, USD (US dollar), AUD (Australian dollar), EUR (Euro), CHF (Swiss franc), and more.This field is required. | EUR |
| price | Enter the fixed price value for the product. This value can only contain numbers. Use numbers and a decimal point only, with no commas (for example, 1299.50, not 1,299.50), or the price won’t parse correctly. Keep empty to remove a previously set fixed price without setting a new one. In this case, the dynamic price conversion rules set for the current country apply. | 29.95 |
| compare\_at\_price | Enter the fixed compare-at price for the product, meaning the original price before any discount. Use numbers and a decimal point only, with no commas (for example, 1299.50, not 1,299.50), or the price won’t parse correctly. If you leave this field blank, the compare-at price is converted from your product base compare-at price using the dynamic price conversion rules for the current country. To prevent a compare-at price from displaying, enter the same value as the sale price. This works only if your theme hides the compare-at price when it is equal to or lower than the sale price. | 49.95 |

**Uploading prices by product**

No setup is required. Add the product\_id column to your file.

* A row with a product\_id and no variant\_id or sku applies the price to all variants of that product.
* If the variant\_id field is populated, the price applies to that variant only.
* You can mix product rows and variant rows in the same file.
* Variants added to a product after the upload do not get the uploaded price. Upload the price again for that product.
* Files without the product\_id column are still supported.

The following example shows a file with both kinds of row:

```csv theme={null}
product_id,sku,variant_id,country_code,currency_code,price,compare_at_price
{{product_id}},,,DE,EUR,29.95,49.95
,,{{variant_id}},DE,EUR,24.95,39.95
```

The first row prices all variants of the product. The second row prices a single variant.

## Populating Your File

Once you’ve set up your file, you can populate it.

> [!NOTE]
>
> Global-e does not support uploading XLS files. Enabling **Editing** in your CSV file may cause your security settings to change the CSV file format to XLS. Before uploading a file, verify that you’ve saved it in the CSV format.

> [!NOTE]
>
> Including commas in your file will not upload.

**To populate your file**

1. Add a list of products with one product per row.
2. Save your file in CSV format.

## Submitting Price Sheets

**To submit price sheets**

1. Select one of the following:

   * **Submit Now** – Skip to **Step 2**.
   * **Schedule Upload** – Set your start date and time.
2. Upload your csv file by clicking **Upload CSV File.**
3. Click **Submit**.

   The file is added to the table showing all the uploaded price sheets.
4. (Optional) If your file fails uploading, resolve the issue and continue with Step 5.

   See [Fixing Validation Errors](https://docs.global-e.com/fixed-price-management-shopify-native.md#fixing-validation-errors) to identify and resolve the cause of your failed upload.
5. Provide an email address.

> [!NOTE]
>
> You can sort the uploaded price sheets by date using the **From Date** and **To Date** fields to the right of the email field.

Global‑e will send you a notification email when you upload a list and a follow-up email when the upload is completed. Note that you can dragdown the email address field from the arrows to see previously entered email addresses.

## Rescheduling Your Upload Date

You can edit your upload schedule as long as your file in the **Ready for upload** stage and has not completed uploading.

**To reschedule your upload date**

1. Click ![](https://mintcdn.com/globale-enterprise/F-UCPkf6gNa18nJ9/images/uuid-391bb5f7-621a-b5a2-59ea-25369cfb2184.png?fit=max\&auto=format\&n=F-UCPkf6gNa18nJ9\&q=85\&s=294411f9e513f3b0270fbdd5ab04011a) located at the far right in a row.
2. Reschedule your upload and click **Update**.

## Cancelling a Publish

You can cancel a publish as long as your file has not completely unloaded. You can do by this by clicking ![](https://mintcdn.com/globale-enterprise/D5z97UtD_lzn1sEI/images/uuid-3410c76d-fb17-d4ad-487e-ac5f69791dda.png?fit=max\&auto=format\&n=D5z97UtD_lzn1sEI\&q=85\&s=1820817a7efff6993ca215e294619e77) located at the far right in a row.

## Reviewing Current Fixed Prices

You can review your current fixed prices by downloading a CSV file containing the current fixed prices. To this, click ![](https://mintcdn.com/globale-enterprise/D5z97UtD_lzn1sEI/images/uuid-2c804b8b-22d6-e99b-39b9-f85d4a481fd2.png?fit=max\&auto=format\&n=D5z97UtD_lzn1sEI\&q=85\&s=6c1533d752156a6584655097826f1bf4) located near the upper right corner of the table.

## Tracking File Status

The Fixed Price Management feature displays the **file upload** and **file validation** statuses when you upload your files. This section describes these statuses.

## File Upload Statuses

The file upload status describes whether your file has uploaded or not, due to an error.

The file upload statuses are shown in the table below:

| **Status** | **Description** |
| - | - |
| Ready for Upload | A submitted file containing some valid prices ready for upload on the scheduled date. |
| Uploading | A submitted file in the process of being uploaded. |
| Uploaded | An uploaded file with successfully updated prices. |
| Partially Uploaded | An uploaded file with a combination of successfully updated and invalid prices. |
| Failed | A completely invalid file. Invalid files are not uploaded. |
| Canceled | A submitted file that a user manually canceled. |

For more information on fixing validation errors, see [Fixing Validation Errors](https://docs.global-e.com/fixed-price-management-shopify-native.md#fixing-validation-errors).

## File Validation Statuses

The file validation status describes whether your file has been validated or not.

The file validation statuses are shown in the table below:

| **Indicator** | **Status** | **Description** |
| - | - | - |
| ![](https://mintcdn.com/globale-enterprise/x4RSAJ5CW3pPE0Za/images/uuid-992cc210-36dd-badc-75d5-2e2fc8d563be.png?fit=max\&auto=format\&n=x4RSAJ5CW3pPE0Za\&q=85\&s=5892e1fc231cc4e76cfedc2206394e29) | Valid | File validated |
| ![](https://mintcdn.com/globale-enterprise/12a3ouYsTLkxux6r/images/uuid-6a705964-c4be-a9b5-70a8-9618f7e6463b.png?fit=max\&auto=format\&n=12a3ouYsTLkxux6r\&q=85\&s=b3cacb58f72b06debeaa8059844d6591) | Partially Valid | Some validation errors were found |
| ![](https://mintcdn.com/globale-enterprise/x4RSAJ5CW3pPE0Za/images/uuid-92a7da1a-c74d-ebbe-7a91-27bd7e31a3ee.png?fit=max\&auto=format\&n=x4RSAJ5CW3pPE0Za\&q=85\&s=2ef1f2503384f271cb6352cdbefe9f48) | Invalid | No prices were accepted |

You can click on the indicators displayed in the table, which opens a csv sheet containing only the valid or invalid rows respectively. All invalid files must be corrected and uploaded separately.

For information on fixing validation errors, see [Fixing Validation Errors](https://docs.global-e.com/fixed-price-management-shopify-native.md#fixing-validation-errors).

## Fixing Validation Errors

This section describes the validation errors that may occur when you upload your price lists.

| Error | Error Message | Resolution |
| - | - | - |
| Too many rowshave the same group key. Duplicates of \{Sku}\_\{VariantId} exceeded max allowed - 500 (near double size of countries count in the database). | The same SKU and Variant ID appear more than once for the same country on line \[Line Number]. Delete duplicate rows and retry. | |
| Invalid SKU - SKU contains whitespace. | Invalid SKUs found in line: \[Line Number]. The SKU contains whitespace. Amend the SKU and retry. | Make sure to use unique names for the Product Code and Secondary Product Code. If the file contains an SKU and not a variant\_id and the SKU is duplicate, the row is skipped. If the file contains both, an SKU and a variant\_id, and the SKU is duplicate or does not exist, the row is skipped. We recommend uploading a file with either the SKU or the variant\_id, not both. It is best to use variant\_id and not an SKU since variant\_id is unique in the Global‑e database whereas SKU is not unique (can be a duplicate SKU). |
| Empty SKU and Variant ID - Both SKU and variant ID are missing. | Both SKU and Variant ID are missing in line: \[Line Number]. provide at least one to proceed. | Make sure each row includes at least one of product\_id, SKU, or Variant ID. See **Invalid SKU - SKU contains whitespace**. |
| Empty Country and Currency Code - Missing country or currency code. | Both Country and Currency codes are missing in line: \[Line Number]. Please provide at least one to proceed. | See **Invalid SKU - SKU contains whitespace**. |
| Invalid country code | Invalid or not operated country code: \[Line Number]. Provide a valid ISO-2 code (e.g., DE for Germany, US for USA) and make sure the country is operated by Global-e, then retry. | If the country, currency, or prices are empty, the entire CSV file fails. Make sure the file contains the correct information. |
| Invalid currency code | Invalid currency code: \[Line Number]. Provide a valid ISO-4217 code (e.g., USD, EUR) and retry. | If the country, currency, or prices are empty, the entire CSV file fails. Make sure the file contains the correct information. |
| Invalid price | Invalid price in line: \[Line Number]. Prices must be numeric. Delete the field content to remove the previously fixed price stored and type the new value. | |
| Price cannot be set to zero (X2 for ListPrice/ SalePrice) - the price is zero. | Price cannot be zero, in line: \[Line Number]. Ensure the price is greater than 0 or leave the field empty and retry | |
| Country-currency mismatch | Currency mismatch, in line: \[Line Number]. The currency code does not match the country. Use the correct currency for that country and retry. | |
| Non-numeric product code | Non-numeric product code in line: \[Line Number]. Provide a numeric product code and retry. | |
| Duplicated SKU | Duplicated SKU in line: \[Line Number]. Remove the duplicate SKU and retry. | See **Invalid SKU - SKU contains whitespace**. |
| No matching SKU and variant product found in the database. | Missing SKU or Variant ID in line: \[Line Number]. No matching product was found in the database. Check the SKU and Variant ID and retry. | Make sure that the SKU / variant\_id exists in Shopify before uploading the CSV file to Global‑e. (Make sure you have uploaded the product to Shopify before uploading the CSV file to Global‑e). |
| Product code or secondary product code is not unique. | NA | See Invalid SKU - SKU contains whitespace. |
| The file is not in CSV format. | | Make sure to save your file in CSV format. |
| Wrong header | NA | Make sure the header is set as one of the following: product\_id,sku,variant\_id,country\_code,currency\_code,price,compare\_at\_price (with product\_id as the first column), or sku,variant\_id,country\_code,currency\_code,price,compare\_at\_price (without product\_id). |
| Spaces in the data | NA | Make sure that the data and header in the file do not contain spaces. |

## Fixed Prices Upload via API

The Upload Fixed Prices API lets you upload your list of fixed prices to Global-e. In addition, you can check the upload status and retrieve the error file.

## Prerequisites

Prepare your CSV file containing your list of fixed prices and populate it.

The columns must be in this order:

```
product_id,sku,variant_id,country_code,currency_code,price,compare_at_price
```

Do not use commas as part of the values in the following fields: price and compare-at-price

For more information, see [Set Up a New Price List](https://docs.global-e.com/fixed-price-management-shopify-native.md#set-up-a-new-price-list).

## Authentication: MerchantGUID

To implement API calls with Global-e the only required information is the `merchantGUID` provided by Global-e.

For authentication, make sure to include your Merchant GUID as part of each call or as part of the header so that Global-e can verify your identity. Make sure to use the appropriate merchantGUID, depending on the Global‑e integration environment used for development or production purposes. See [Global-e Environments](https://docs.global-e.com/shipping-with-non-global-e-carriers.md#global-e-environments).

**MerchantGUID in URL**

Add your MerchantGUID as part of each API URL.

**MerchantGUID as part of the header**

Add your MerchantGUID as part of the header as illustrated below.

```
curl --location 'https://[globale domain]/[API]' \
--header 'MerchantGUID: <MERCHANT_GUID>' \
--header 'Content-Type: application/json' \
--data-raw '
```

## Flow

1. Call the [UploadFile](https://docs.global-e.com/fixed-price-management-shopify-native.md#uploadfile) endpoint to upload your Fixed Prices CSV file to Global-e.
2. Call the [GetUploadedFileDetails](https://docs.global-e.com/fixed-price-management-shopify-native.md#getuploadedfiledetails) to get the details of the file you uploaded and verify the Upload status.
3. Call [GetFileWithValidationErrors](https://docs.global-e.com/fixed-price-management-shopify-native.md#getfilewithvalidationerrors) to retrieve the file containing the errors.

If previously configured, you can retrieve your configuration file, modify your price list, and re-upload it. However, note that the prices (data) are overwritten and a new `RunId` (Global-e ID) is created.

## UploadFile

Upload your Fixed Price CSV File to Global-e.

**MethodURL**

```
POST https://<domain address>/PCE/UploadFile?merchantGUID=<Merchant GUID>
```

**Request**

`<Fixed Price CSV File>` (from data)

**Response**

```
200 OK:
{
    "RunId": "03fb441b-55ec-4392-b0ae-2e1805c6f492"
}


```

**Errors**

| HTTP Status Code | Message | Description |
| - | - | - |
| `400` | \{ "Message": "CSV file contains rows with invalid  data. Make sure the file has the correct format  and contains the correct information.", "Errors": \[ ",43416058200314,,PLN,201,201,400", ",43416058200314,FR,EUR,301,401,400"   ] } | This file has the wrong column format and/or values. Check the rows that returned the error. |
| `400` | "Only one file should be uploaded. Make sure to upload only one file." | This endpoint expects only one file per request. |
| `400` | "The uploaded file is empty and cannot be processed. Make sure to populate the file correctly." | The file is empty or did not load correctly. |
| `400` | "The format of the uploaded file is incorrect. Please upload a CSV file. Make sure to save your file to .csv format." | The uploaded file had the wrong extension. |
| `500` | "Failed to upload the file. Please contact Support." | This is an internal error. If it appears, please contact Support. |

**CUrl EXAMPLE:**

```
curl--location--request POST 'https://<domain>.com/PCE/UploadFile?merchantGUID=<Guid>' \
--form '=@"/<Full Path Name>.csv"'
```

## GetUploadedFileDetails

This endpoint returns the details of the uploaded file, including the upload completion status.

**PATH:** \[https\://\<domain address> /PCE/GetUploadedFileDetails?merchantGUID=\<Merchant GUID>\&runId=\<GUID provided by Upload file endpoint>]\(https\://\<domain address> /PCE/GetUploadedFileDetails?merchantGUID=\<Merchant GUID>\&runId=\<GUID provided by Upload file endpoint>)

**TYPE:** `GET`

**RESPONSE:**

```
200 OK:
{
    "RunId": "84f9929c-1ea1-4edd-bc56-c4ef73a92e88",
    "FileName": "[Ecommerce_Platform_Name]_QA_Artem_01.08.2023_06_all_valid.csv",
    "DateCreated": "2023-08-11T10:04:57.462022+00:00",
    "Status": "Completed",
    "HasErrors": false,
    "CompletionPercentage": 100
}
```

**PARAMETERS:**

| Parameter | Type | Description |
| - | - | - |
| `RunId` | string | The Global-e file IdSample UID format: `84f9929c-1ea1-4edd-bc56-c4ef73a92e88` |
| `FileName` | string | The file name given by the merchant in CSV format |
| `DateCreated` | string | The file upload date. |
| `Status` | string | Statuses:`Submitted`: When the file is first uploaded, the status is set to "Submitted". (Submitted: 0%)`Processing`: As the file is being uploaded, the status changes to Processing. (Example: Processing: 64%)`Completed`: If the upload finishes without errors, the status changes to Complete. (Completed: 100%)`Failed`: If the upload fails due to an error, the status changes to Failed. See Errors to troubleshoot the issues. (Failed: 0%) |
| `HasErrors` | bool | Whether the file upload has errors. |
| `CompletionPercentage` | Integer | Shows the progress of the file upload completion in per cent.Note: The integer value is a number without the per cent symbol.Example: "CompletionPercentage": 100 |

**ERRORS:**

| HTTP Status Code | Message | Description |
| - | - | - |
| `400` | "Cannot find the information for the current runId!" | The application cannot find the upload with this `RunId`.This can happen if the file did not upload correctly, the `RunId` is empty, or if the `RunId` has been modified.Verify that your file has uploaded correctly and returns a valid `RunId`. |
| `500` | "Failed to get the uploaded file’s \{runId} for PCE.” | Unexpected internal error during file upload. Please contact Support.PCE: Price Calculation Engine |

## GetFileWithValidationErrors

This endpoint always returns a CSV file with the headers. If there are errors, the file contains the rows where errors were identified.

**PATH:** \[https\://\<domain address> /PCE/GetFileWithValidationErrors?merchantGUID=\<Merchant GUID>\&runId=\<GUID provided by Upload file endpoint>]\(https\://\<domain address> /PCE/GetFileWithValidationErrors?merchantGUID=\<Merchant GUID>\&runId=\<GUID provided by Upload file endpoint>)

**TYPE:** `GET`

**RESPONSE:**

```
          200 OK:
          File (application/octet-stream)
```

**ERRORS:**

| HTTP Status Code | Message | Description |
| - | - | - |
| `400` | "Cannot find the information for the current runId!" | The application cannot find the upload with this `RunId`.This can happen if the file did not upload correctly, the `RunId` is empty, or if the `RunId` has been modified.Verify that your file has uploaded correctly and returns a valid `RunId`. |
| `400` | "Failed to get the validated file containing the rows with errors for PCE." | Unexpected internal error during file upload. Please contact Support.PCE: Price Calculation Engine |

## Set up a New Price List

The following procedure details the steps required to set up a new list of fixed prices and upload it to Global‑e.

## Step 1. Prepare your Price List in CSV Format

In your CSV file, make sure to name the columns headers A through G, as shown below:

```csv theme={null}
product_id,sku,variant_id,country_code,currency_code,price,compare_at_price
```

## Field Descriptions and Requirements

| **Headers / Fields** | **Description** |
| - | - |
| **product\_id** | Enter the Shopify Product ID. If both the `Variant ID` and `SKU` fields are empty, the price applies to all variants of that product. If the product does not exist in Global-e yet, the row is rejected as an invalid product. Not required if using Variant ID or SKU. |
| **SKU** | Enter the Product SKU as it appears in your product catalogue. The SKU may not include spaces. Each row must include at least one of the `product_id`, `SKU`, or `Variant ID` fields. Not required if using Product ID or Variant ID. |
| **Variant ID** | Enter the Product Variant ID, as assigned in your product catalogue. Each row must include at least one of the `product_id`, `SKU`, or `Variant ID` fields. Not required if using Product ID or SKU. |
| **country\_code** | Enter the ISO-2 country code to indicate the country relevant to this price.For instance, DE (Germany), US (USA).If this field is empty, the `currency_code` field must be populated. |
| **currency\_code** | Enter the 3-char currency code (ISO-4271) to indicate the currency relevant for this change.For instance, USD (US dollar), AUD (Australian dollar), EUR (Euro), CHF (Swiss franc), and more.If this field is empty, the `country_code` field must be populated. |
| **price** | Enter the fixed price value for the product. This value can only contain numbers. Use numbers and a decimal point only, with no commas (for example, 1299.50, not 1,299.50), or the price won’t parse correctly. Keep empty to remove a previously set fixed price without setting a new one. In this case, the dynamic price conversion rules set for the current country apply. |
| **compare\_at\_price** | Enter the fixed compare-at price for the product, meaning the original price before any discount. Use numbers and a decimal point only, with no commas (for example, 1299.50, not 1,299.50), or the price won’t parse correctly. If you leave this field blank, the compare-at price is converted from your product base compare-at price using the dynamic price conversion rules for the current country. To prevent a compare-at price from displaying, enter the same value as the sale price. This works only if your theme hides the compare-at price when it is equal to or lower than the sale price. |

## Step 2. Populate your CSV File

> [!NOTE]
>
> When enabling editing in your CSV file, your security settings may change the CSV file format to Excel. Make sure to save your file back to CSV before uploading it to Global-e.

**To populate your CSV file:**

1. Add your list of products, one product per row with the relevant information in the relevant column, according to the [Field Descriptions and Requirements](#field-descriptions-and-requirements) in Step 1.

   To ensure optimal accuracy, make sure to use the following values when populating fixed price data in your CSV file.

   > [!WARNING]
   >
   > Do not include commas in the prices you list in the CSV file as the prices will not parse correctly.

   * **Price per country and currency:**

     ```
     Header: sku,variant_id,country_code,currency_code,price,compare_at_price
     Value: {{sku}},{{variant_id}},DE,EUR,6,6    
     ```

     OR (based on `variant_id`):

     ```
     Header: sku,variant_id,country_code,currency_code,price,compare_at_price
     Value: ,{{variant_id}},DE,EUR,6,6
     ```
   * **Price per currency (affects all countries with the same currency):**

     ```
     Header: sku,variant_id,country_code,currency_code,price,compare_at_price
     Value: {{sku}},{{variant_id}},,EUR,6,6       
     ```

     OR (based on `variant_id`):

     ```
     Header: sku,variant_id,country_code,currency_code,price,compare_at_price
     Value: ,{{variant_id}},,EUR,6,6  
     ```
   * **Price per product (affects all variants of the product):**

     ```
     Header: product_id,sku,variant_id,country_code,currency_code,price,compare_at_price
     Value: {{product_id}},,,DE,EUR,6,6
     ```
2. When done, make sure to save your file as CSV.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.