123 Stores Account Integration

Sellercloud Support

Open a ticket with Sellercloud Support and request the following plugins be installed on your server:

• 123 Stores Order Import EDI 850 – Imports orders from 123 Stores to Sellercloud in EDI 850 format and sends acknowledgment back in EDI 997 format.
• 123 Stores Order Export EDI 855 – Sends order acknowledgment to 123 Stores in EDI 855 format.
• 123 Stores Tracking Export 856 EDI – Exports tracking information from Sellercloud to 123 Stores in EDI 856 format.
• 123 Stores Invoice Export EDI 810 – Exports invoices from Sellercloud to 123 Stores in EDI 810 format.
• 123 Stores Inventory Export EDI 846 – Exports inventory from Sellercloud to 123 Stores in EDI 846 format.

If necessary, you can request additional customizations or other plugins for this integration. Any such modifications will be billable.

123 Stores Support

You must contact 123 Stores Support for the following:

• Your FTP details: Server Name, Username, and Password. You will need them when setting up the scheduled tasks to automate the plugins.
• Provide 123 Stores with your Customer ISA ID.

Custom Company Settings

Create the following Custom Company Settings.

On your Default company:

• ISAControlNumber

• STControlNumber

• ISAControlNumber

On the company created for the integration:

• 123Store_ISAID – Provided by 123 Stores.
• 123Store_Customer_ISAID – Your ISA ID. Typically, this is your phone number, but it can be anything you set up with 123 Stores.
• 123Store_CustomerQualifier – Value is ZZ.
• 123Store_Qualifier – Value is 12.
• 123Store_Net_Term_Days – The default is 30 days. These are the Payment Term days we send with the EDI810 Invoice for each order.
• 123Store_Net_Discount_Percentage – The default is 0. You can use this setting to configure a discount for your orders’ Payment Terms. It will be available for a period of time configured in the 123Store_Net_Discount_Days setting. We send this information with the EDI810 Invoice for each order.
• 123Store_Net_Discount_Days – The default is 0. This setting determines the number of days within the Payment Term that the discount is available. We send this information with the EDI810 Invoice for each order.
• 123Store_IsInProduction – The value should be set to False during the EDI testing process. Once you have completed it, set it to True to move into Production.

Custom Product Columns

Create the following Custom Product Columns:

• (Optional) STORE123_SKU – If the 123 Stores product ID differs from the Sellercloud SKU, enter it here. This will help us match the correct products when importing new orders. The data type is String.
• STORE123_DAYSLEADTIMETOSHIP – The time it takes for a product to be shipped after receiving it from 123 Stores. The data type is Integer.
• (Optional) STORE123_SAFETYQTY  – The product’s Safety Quantity is subtracted from the available quantity to prevent overselling. The data type is Integer.
• (Optional) STORE123_ENABLED – Enable only specific products for 123 Stores. Set to True for any products you want to send with the Inventory Export plugin. The data type is Boolean.

Custom Order Columns

Create the following Custom Order Column:

• STORE123_AGREEMENT_NUMBER – The Order Import plugin automatically fills in this column.

Order Import

The 123 Stores Order Import EDI 850 plugin imports orders from 123 Stores to Sellercloud in EDI 850 format and sends acknowledgment back in EDI 997 format for successfully created orders.

New orders are created as Unshipped and Charged. To ensure the correct Shipping Carrier and Method are applied to each order, you must configure an Import Mapping Profile. Order items are matched by Sellercloud Product ID and the values in the STORE123_SKU custom product column.

Automate Order Import

To create a Scheduled Task that imports orders:

1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
2. Click the green + icon: Create New Scheduled Task.
3. Complete as follows:
   1. Click Task Type and select Import Orders.
   2. Set the Task Name.
   3. Select the Company.
   4. Select the Start Time.
   5. Click CREATE.
4. The Scheduled Task Details page will open automatically. Click the Edit button at the top right corner.
5. In the Details panel:
   1. Click Create Orders For Company and select the company designated for this integration.
   2. Click the Plugin menu and select 123 Stores Order Import EDI 850.
6. In the Import Options panel, set Import From to FTP and fill out the FTP fields with the credentials provided by 123 Stores.
7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
8. In the General panel, click the Enable button.
9. Click Save.

Shipping Method Mapping

The 123 Stores Order Import EDI 850 does not have a default Shipping Method Mapping to set the Shipping Carrier and Method on your orders. You can create an Import Mapping Profile of type Orders to ensure each SCAC code is processed correctly.

The Profile Name must be set to 123 Store. Do not configure the order columns on the Mapping Profile Details page. Instead, access the Toolbox > Shipping Method Mapping > click Edit > click the + icon in the panel header. In the pop-up module, fill in:

• Method received – the shipping method codes received with the EDI 850 order import. Reach out to 123 Stores support for the list.
• Local Carrier – select the shipping carrier you will use to fulfill orders with that specific code.
• Local Service – select the shipping method.
• Rush Order – check this box to mark orders with this specific shipping method as Rush.

Once you Add all the shipping code mappings, click Save. If the profile name is correct, the plugin will automatically apply it to all imported orders.

Order Acknowledgement

The 123 Stores Order Export EDI 855 plugin sends order acknowledgment in EDI 855 format and marks orders as acknowledged after export. This plugin accepts or rejects whole orders. If an order has been Split, it will export each order separately.

Before you move on, create a Saved Search for orders filtered by:

• Company – The company you created for the integration
• Order Status – InProcess Or Completed
• Payment Status – Charged
• Exported – Not Exported
• Order Ack (Accept) – No

Automate Order Acknowledgment

To create a Scheduled Task that exports order acknowledgments:

1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
2. Click the green + icon: Create New Scheduled Task.
3. Complete as follows:
   1. Click Task Type and select Export Orders.
   2. Set the Task Name.
   3. Select the Company.
   4. Select the Start Time.
   5. Click CREATE.
4. The Scheduled Task Details page will open automatically. Click the Edit button at the top right corner.
5. In the Details panel:
   1. Click the User ID menu and select your email.
   2. Click the Saved Search menu and select the saved search you created earlier.
   3. Click the Export Via menu and select 123 Stores Order Export EDI 855.
   4. Check Mark Orders As Exported.
   5. Check This is Order Ack (Accept).
6. In the Import Options panel, set Import From to FTP and fill out the FTP fields with the credentials provided by 123 Stores.
7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
8. In the General panel, click the Enable button.
9. Click Save.

Tracking Export

The 123 Stores Tracking Export 856 EDI plugin exports tracking from Sellercloud to 123 Stores following the 856 EDI format.

Before you move on, create a Saved Search for orders filtered by:

• Company – The company you created for the integration
• Order Status – InProcess Or Completed
• Shipping Status – FullyShipped
• Payment Status – Charged
• Tracking Uploaded – No

Automate Tracking Export 

To create a Scheduled Task that imports order tracking:

1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
2. Click the green + icon: Create New Scheduled Task.
3. Complete as follows:
   1. Click Task Type and select Export Orders.
   2. Set the Task Name.
   3. Select the Company.
   4. Select the Start Time.
   5. Click CREATE.
4. The Scheduled Task Details page will open automatically. Click the Edit button at the top right corner.
5. In the Details panel:
   1. Click the User ID menu and select your email.
   2. Click the Saved Search menu and select the saved search you created earlier.
   3. Click the Export Via menu and select 123 Stores Tracking Export 856 EDI.
   4. Check This Is Tracking Export.
6. In the Export Options panel, set Export to to FTP and fill out the FTP fields with the credentials provided by 123 Stores.
7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
8. In the General panel, click the Enable button.
9. Click Save.

Invoice Export

The 123 Stores Invoice Export EDI 810 plugin exports invoices from Sellercloud to 123 Stores in EDI 810 format. The plugin includes the values configures in the 123Store_Net_Term_Days, 123Store_Net_Discount_Percentage, and 123Store_Net_Discount_Days custom company settings.

Before you move on, create a Saved Search for orders filtered by:

• Company – The company you created for the integration.
• Shipping Status – Fully Shipped.
• Order Status – InProcess Or Completed
• Invoice Uploaded – No
• Tracking Uploaded – Yes

Automate Invoice Export

To create a Scheduled Task that exports invoices:

1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
2. Click the green + icon: Create New Scheduled Task.
3. Complete as follows:
   1. Click Task Type and select Export Orders.
   2. Set the Task Name.
   3. Select the Company.
   4. Select the Start Time.
   5. Click CREATE.
4. The Scheduled Task Details page will open automatically. Click the Edit button at the top right corner.
5. In the Details panel:
   1. Click the User ID menu and select your ID.
   2. Click the Saved Search menu and select the saved search you created earlier.
   3. Click the Export Via menu and select 123 Stores Invoice Export EDI 810.
   4. Check This Is Invoice Export.
6. In the Export Options panel, set Export to to FTP and fill out the FTP fields with the credentials provided by 123 Stores.
7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
8. In the General panel, click the Enable button.
9. Click Save.

Inventory Export

The 123 Stores Inventory Export EDI 846 plugin exports inventory from Sellercloud to 123 Stores in EDI 846 format. It sends aggregate qty and considers the value set in the product’s safety qty custom column.

Optionally, you can enable only specific products for 123 Stores by setting their STORE123_ENABLED custom product column to True:

• For one product at a time: Go to the Product Details Page > click Toolbox, and select Custom Columns > click Edit, update the STORE123_ENABLED column, and Save.
• For multiple products in bulk: Follow the steps to Bulk Update Products and use the STORE123_ENABLED column – set it to True for all products you want to enable.

Unlike core integrations, plugin integrations don’t require products to be in the company with the scheduled tasks. The export will include the products you select with your Saved Search.

Next, create a Saved Search for products filtered by STORE123_ENABLED—True. You can optionally add more filters to the search to narrow the export further.

Automate Inventory Export

To create a Scheduled Task that imports inventory:

1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
2. Click the green + icon: Create New Scheduled Task.
3. Complete as follows:
   1. Click Task Type and select Export products.
   2. Set the Task Name.
   3. Select the Company.
   4. Select the Start Time.
   5. Click CREATE.
4. The Scheduled Task Details page will open automatically. Click the Edit button at the top right corner.
5. In the Details panel:
   1. Click the User ID menu and select your email.
   2. Click the Saved Search menu and select the saved search you created earlier.
   3. Click the Export Via menu and select 123 Stores Inventory Export EDI 846.
6. In the Export Options panel, set Export to to FTP and fill out the FTP fields with the credentials provided by 123 Stores.
7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
8. In the General panel, click the Enable button.
9. Click Save.