Overview
JCPenney, often simply referred to as JCP, is a department store chain with a long history in the retail industry. They sell a wide range of products, including clothing, footwear, accessories, jewelry, beauty products, home furnishings, and appliances.
Integrating JCPenney into Sellercloud allows you to download orders and send inventory and order tracking information. This integration works through EDI documents transmitting information between the two services. The document exchange goes through CommerceHub – a third-party platform that provides the Secure File Transfer Protocol (SFTP) server and credentials.
The following plugins are currently available in Sellercloud:
- Order Import – Imports orders from JCPenney to Sellercloud in EDI 850 format.
- Tracking Export – Exports tracking information to JCPenney in EDI 856 format.
- Inventory Export – Exports inventory to JCPenney in EDI 846 format.
If necessary, you can contact Sellercloud Support to request additional customizations or other plugins for this integration. Any such modification will be billable.
Prerequisites
Before you can integrate JCPenney with Sellercloud, complete the following requirements.
Contact CommerceHub for your SFTP details: Server Name, Username, and Password. You will need them when setting up the scheduled tasks to automate the plugins. Additionally, make sure to ask for their ISA ID and Remit ID – you will need those when populating the custom company settings.
Custom Company Settings
Create the following Custom Company Settings.
On your default company:
- STControlNumber
- GSControlNumber
- ISAControlNumber
- JcPenney Customer ISA ID – Enter a unique phone number not used for any other integration.
- JcPennyQualifier – Obtain from JC Penny. Usually 12.
- JcPennyCustomerQualifier – Usually ZZ.
- JcPenneyReceiverID – Contact JCPenney for the value.
- GS1_CompanyPrefix – Enter your GS1 Company Prefix here.
- JcPenneyLeaveOrdersUnpaid – Optional; if set to True, will import orders as unpaid.
- JCP_DefaultCarrier – Optional setting to define a default carrier for JCP Orders.
- JCP_DefaultShippingMethod – Optional, if the code sent from JCPenney contains UNSP and this setting is populated, it will set the default shipping method.
On the company created for the integration:
- JcPenney_ShippingRequiresThirdPartyBilling – Optional; if set to True, orders will require Third-Party Billing.
- ExportMultipleWarehousesOnJCPenney846 – Optional, set to True to map warehouses for the Inventory Export plugin to use multi-warehouse logic.
- JCPenney_WarehouseCodeMapping – If the setting above is enabled, you must map warehouses here by following the format WarehouseID,WarehouseCode – for example: 123,WHNY;456,WH2
Sellercloud Support
You must contact Sellercloud Support and request:
- To install the JCPenney Plugins on your server.
- The following Custom Product and Order Columns:
Custom Product Columns
- JCPENNEY_SKU – A product’s ID at JCPenney.
- JCP_Enabled – Optional, used to enable only specific products for JCPenney. Set to True for any products you want to send with the Inventory Export plugin.
- JCPENNEY_SAFETY_QTY – Optional, used to set a Safety Quantity for products on JCPenney.
Custom Order Columns
- IsShipToStore – automatically populated by the Order Import Plugin.
- JCPenney_SoldTo – Optional, used to save the N1 * SO (Sold To Name) value.
Order Import
This plugin imports order data from JCPenney to Sellercloud in EDI 850 format.
Automate Order Import
To create a Scheduled Task that imports orders:
- Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
- Click the green + icon: Create New Scheduled Task.
- Complete as follows:
- Click Task Type and select Import Orders.
- Set the Task Name.
- Select the Company.
- Select the Start Time.
- Click CREATE.
- The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
- Click the Edit button on the top right.
- In the Details section:
- Click Create Orders For Company and select the company designated for this integration.
- Click the Plugin menu and select JCPenney EDI OrderImport.
- In the Import Options section, set Import From to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
- In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
- In the General section:
- Click the Enable button.
- In the Note field, type FTP.
- Click Save on the top right.
Tracking Export
This plugin exports tracking from Sellercloud to JCPenney following the 856 EDI format.
The plugin includes SSCC ID per package if it is a Ship To Store order. However, note that the SSCC is generated by the invoice plugin. So, for Ship To Store orders, you must first print the packing slip, and then when the tracking is exported, it will include the SSCC.
For Split Orders, the Tracking Export plugin now exports parent and child orders together by adding the child packages and items to the parent item and exporting a single transaction of the parent.
- Parent orders which are not fully shipped are skipped together with their child orders.
- Child orders that are not fully shipped are skipped but won’t stop their parent from being exported. This will mark the Order JCP as partially shipped, and the child order in Sellercloud will be marked as Source Notified For Shipping.
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
- Exported – Not Exported
Automate Tracking Export
To create a Scheduled Task that exports order tracking:
- Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
- Click the green + icon: Create New Scheduled Task.
- Complete as follows:
- Click Task Type and select Export Orders.
- Set the Task Name.
- Select the Company.
- Select the Start Time.
- Click CREATE.
- The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
- Click the Edit button on the top right.
- In the Details section:
- Click the User ID menu and select your ID.
- Click the Saved Search menu and select the saved search you created earlier.
- Click the Export Via menu and select JCPenney EDI 856.
- Check Mark Orders As Exported.
- Check This Is Tracking Export.
- In the Export Options section, set Export To to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
- In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
- In the General section, click the Enable toggle button.
- Click Save on the top right.
Inventory Export
This plugin exports inventory quantities (total or per warehouse) from Sellercloud to JCPenney in EDI 846 format. Note that product prices are not included.
Optionally, you can enable only specific products for JCPenney by setting their JCP_Enabled Custom Column for Products to True:
- For one product at a time: go to the Product Details Page > click Toolbox and select Custom Columns > click Edit, update the JCP_Enabled column, and Save.
- For multiple products in bulk: follow the steps to Bulk Update Products and use the JCP_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 JCP_Enabled – True. Optionally, you can add more filters to the search to narrow down the export further.
Automate Inventory Export
To create a Scheduled Task that exports inventory:
- Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
- Click the green + icon: Create New Scheduled Task.
- Complete as follows:
- Click Task Type and select Export Products.
- Set the Task Name.
- Select the Company.
- Select the Start Time.
- Click CREATE.
- The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
- Click the Edit button on the top right.
- In the Details section:
- Click the User ID menu and select your ID.
- Click the Saved Search menu and select the saved search you created earlier.
- Click the Export Via menu and select JCPenney ProductExport EDI 846.
- In the Export Options section, set Export To to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
- In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
- In the General section, click the Enable toggle button.
- Click Save on the top right.
Configure PDF Invoices
This plugin exports invoices with information about your orders and the products they include according to the format required by JCPenney. This plugin doesn’t require a scheduled task.
If it is a Ship To Store order, it will also generate an SSCC ID per package and print each barcode and ID on the invoice. The SSCC will then be saved back to the package.
The SSCC code is made up of the first 17 digits of your GS1 Company Prefix (pulled from the custom setting GS1_CompanyPrefix), the package ID, the order ID, and the order source order ID (numerics only). A check digit is then added to the end of the SSCC.
To set up the invoice plugin:
- Go to the Company Settings of the company you created for the integration
- Click Toolbox and select Invoice Settings.
- Click Per Channel Preferences.
- For Website, select Plugin > JCPenney Packing Slip.
- Click Save.