Importing Locations - Fabric
Import Locations
The Import Locations feature allows you to efficiently add multiple store or warehouse locations to fabric. This streamlined process eliminates the need for manual data entry, reducing the risk of errors while saving you time and effort. To assist with this process, fabric provides CSV template files for Locations, Temporary Location Capacity, and Scheduled Location Closures.
Prerequisites
- Ensure that you have Orders & Inventory Editor or Administrator privileges to fabric Orders. For more information, see the Role-Based Access Control section.
Importing Locations
- In the left menu, click Inventory > Locations. The Locations page is displayed.
- Click Import. The Import CSV file window is displayed.
- Select one of the following fields depending on your requirements:
- Locations: Use this option to import locations that currently do not exist in fabric.
- Scheduled Location Closures: Use this option to import location schedule updates and changes.
- Temporary Location Capacity: Use this option to import temporary location capacity updates.
You must select the correct field to download its corresponding template.
- Download the sample template by clicking template here at the bottom of the window.
- Depending on the CSV file you downloaded, review the required and optional columns for the template:
- Locations template for the location.csv file.
- Location outages template for the location_outage.csv file.
- Location capacity overrides template for the location_capacity_override.csv file.
- In the Import CSV file window, do one of the following:
- Drag your file to the drag and drop field.
- Click Select a File from your computer and select your CSV file.
The file is uploaded displaying the file name and size. 7. (Optional) You can click Remove to delete the uploaded file or Replace to replace the file. 8. Click Submit.
The import status can be viewed on the Inventory > Activity Log page.
Locations CSV file template
Importing locations requires updating the location.csv template file. If a field in a column remains blank, it’s set to null by the system. Ensure fields don’t contain blank spaces, returns, line breaks, or other characters. Not following the format suggested in the template can result in errors when uploading.
| Column | Description |
|---|---|
| locationNum (Required) | Specifies the unique location number. |
| name (Required) | Specifies the location name. |
| isActive | Determines if the location is active or inactive for order fulfillment operations. This can be set to TRUE for active and FALSE for inactive. |
| address_addressLine1 | Specifies the locations first address line. |
| address_addressLine2 | Specifies the locations second address line. |
| address_addressLine3 | Specifies the locations third address line. |
| address_addressLine4 | Specifies the locations fourth address line. |
| address_city | Specifies the location city name. |
| address_countryCode | Specifies the locations country code. For example, CA for Canada or US for United States. |
| address_state (Required) | Specifies the locations region, state, or province. |
| address_postalCode | Specifies the locations postal or zip code. |
| address_type | Specifies the locations address type. For example, Home or Business. |
| contacts | Specifies the locations contact details. Each child attribute in the contacts object is separated by an underscore. For example, HOME_home@gmail.com_604-999-1860_JoeMadison. |
| capacity_isInfiniteAllocation | Determines if the location has a capacity limit or not. Set to TRUE to disable capacity limit and FALSE to enable capacity limit. |
| capacity_maxAllocations | Determines the locations capacity limit amount. For example, 100 allocations. This value is required if capacity_isInfiniteAllocation is FALSE. |
| capacity_currentAllocations | Specifies the locations current amount of allocations. This value is required if capacity_isInfiniteAllocation is FALSE. |
| operatingHours_day_hours_open_hours_close_hours_type | Specifies the locations operating hours. The following format is used to provide operation hours, day of the week, store opening time in 24 hour format, closing time in 24 hour format, location type. For example, MONDAY_2022-10-19T15:26:30.884+00:00_2022-10-19T15:26:30.884+00:00_PICKUP. |
| attributes_source | Example of a custom source attribute. By default this columns values are empty. |
| attributes_openedAt | Example of a custom date-time attribute. By default this columns values are empty. |
| attributes_region | Example of a custom region attribute. By default this columns values are empty. |
| services_channel | Specifies the locations sales channel ID. |
| services_brand | Specifies the locations brands. |
Location outages CSV file template
Importing location outages requires updating the location_outage.csv template file. If a field in a column remains blank, it’s set to null by the system. Ensure fields don’t contain blank spaces, returns, line breaks, or other characters. Not following the format suggested in the template can result in errors when uploading.
| Column | Description |
|---|---|
| disabledFulfillmentMethods (Required) | Specifies the fulfillment method you want to disable for a location. For example, `[\ |