Importing 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

1. In the left menu, click Inventory > Locations.

   The Locations page is displayed.

2. Click Import.

   The Import CSV file window is displayed.

3. 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.

4. Download the sample template by clicking template here at the bottom of the window.

5. 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.

6. 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, [e-mail]_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, ["PICKUP"].
locationNumber (Required)	Specifies the unique location number.
schedule.endDate	Specifies the end date and time of the location outage in UTC format. For example, 2025-12-20T09:30:31.198Z.
schedule.isIndefinite (Required)	Determines whether the location outage remains in effect indefinitely. Set to FALSE if you have provided a start and end data for the outage. Set to TRUE if you want the outage to remain in effect indefinitely.
schedule.startDate	Specifies the start date and time of the location outage in UTC format. For example, 2025-12-20T09:30:31.198Z.
outageNumber	Indicates the reason for the outage.

Location capacity overrides CSV file template

Importing capacity overrides requires updating the location_capacity_override.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
capacity (Required)	Specifies the temporary capacity increase amount. For example, 100.
locationNumber (Required)	Specifies the unique location number.
schedule.startDate	Specifies the start date and time of the capacity override in UTC format. For example, 2025-12-20T09:30:31.198Z.
schedule.endDate	Specifies the end date and time of the capacity override in UTC format. For example, 2025-12-20T09:30:31.198Z.
schedule.isIndefinite (Required)	Determines whether the capacity override remains in effect indefinitely. Set to FALSE if you have provided a start and end data for the override. Set to TRUE if you want the override to remain in effect indefinitely.