ApparelMagic Desktop integration

ApparelMagic Desktop will be connected to NuORDER through a flat file integration, meaning the two systems will be generating CSV files of your data and transferring them back and forth through an FTP. ApparelMagic Desktop has utilized the NuORDER SFTP to develop a data connection between the two systems. AMD will be connected to NuORDER through a flat file integration, meaning the two systems will be generating CSV files of your data and transferring them back and forth through an FTP. This involves collaborating with a developer to map your data according to your business requirements.

Data flow Requirements Sync frequency Turnaround time Your team's involvement

Your responsibilities NuORDER team's involvement NuORDER's responsibilities Data transfer method What's supported

 

Data flow

The data flow encompasses the following elements

• Products - from ApparelMagic to NuORDER 
• Customers - from ApparelMagic to NuORDER 
• Inventory - from ApparelMagic to NuORDER 
• Orders - from NuORDER to ApparelMagic 

back to top

Requirements

Version: Version of Apparel Magic and Filemaker is critical. You must be using ApparelMagic Desktop Version 10.M (or greater) and Filemaker 13 (or greater) to integrate with NuORDER.

If you need help checking the version number of your system, check the Standards screen (Administration menu > Standards). The release identifier will be towards the bottom of the page. If you need to update your version of Apparel Magic (which sometimes also requires an update of Filemaker), please keep in mind that any customizations on Apparel Magic will also need to be re-applied by a 3rd party developer.

FTP Automation: To automate the data feeds via FTP, you will need the 360Works FTPeek plug-in for ApparelMagic. If you do not already have 360Works, let us know; we will provide you with a license at no additional cost.

Someone on site at your Company will then need to install the Plugin on the Filemaker server. If you do not have someone who can comfortably do this, we can recommend a developer to assist with this remotely. (Separate fee associated with developer, and will usually take an hour to install)

The FTP will be hosted by NuORDER. We will provide you with your FTP credentials. 

back to top

Sync frequency

The data feeds will be updated multiple times daily based on the agreed sync times. Whenever mapped changes occur in AMD, such as items, inventory levels, or customer data, they should be synced to NuORDER. Please connect with your Developer for your agreed sync frequency and mappings. Orders will sync from NuORDER to the shared FTP in approximately 15 minutes. 

back to top

Turnaround time

The ApparelMagic Desktop integration project is expected to take around 12-16 weeks from the project kickoff to completion. This timeline encompasses all stages of the rollout, including:

• Planning and discovery sessions
• Data cleanup and preparation on your end for ApparelMagic Desktop integration
• Testing and review in the NuORDER sandbox
• Adjustments as needed
• Final review and sign-off
• Transition from the sandbox to production
• Post-launch troubleshooting

back to top

Your team's involvement

From your team, the following key roles will be involved:

1. Your ApparelMagic Desktop Administrator or a technically proficient team member familiar with your ApparelMagic Desktop setup.

2. A Sales or Operations Manager who understands your business structure and the sales process. 

3. You will need a Third Party Integration Engineer who will configure your ApparelMagic account to import & export the data feeds for NuORDER. We recommend working with Nicola Fergusson - nicola101@icloud.com or Collin at colin@quecentric.com, whom have previously worked on AMD integrations with NuORDER. They will work with us on the back-end setup. If you need any customization from the standard set-up, Nikki or Collin can provide this support for a fee.

back to top

Your responsibilities

You will be responsible for:

• Providing detailed information about your ApparelMagic setup and sales  process.

• Ensuring that your ApparelMagic Desktop portal is ready for integration (e.g., product, customer, and inventory data is populated in ApparelMagic).

• Offering insights into data fields used in ApparelMagic and parameters for  item/customer synchronization with NuORDER.
• Making necessary bulk adjustments, such as adding new fields to your ApparelMagic Desktop data, for an optimal NuORDER user experience.

• Designating & reviewing data in the NuORDER sandbox and providing feedback.

• Creating & reviewing test orders in NetSuite and offering feedback.

• Providing final approval for the go-live stage.Monitoring data feeds daily after going live to ensure correctness.

• Collaborating with us to address any unforeseen issues that may arise once your team is actively using NuORDER in the live sales environment. 

back to top

NuORDER team's involvement

From the NuORDER team, you can expect:

1. An Integration Manager who will serve as your main point of contact, overseeing the project and guiding you throughout the rollout.

back to top

NuORDER's responsibilities

We will be responsible for:

• Gaining an understanding of your specific ApparelMagic setup and sales process.
• Working with AMD as they configure the data files to import & export based on your specific business rules.
• Synchronizing test data into the NuORDER sandbox.
• Synchronizing test orders into AMD.
• Ensuring a smooth transition from the sandbox to production.
• Keeping your team updated throughout the process and addressing any delays as they arise.
• Resolving any unexpected issues that may occur after the go-live stage.

back to top

Data transfer method

Data will be transferred using FTP or Flat File.

back to top

What's supported

These are the capabilities and callouts for what's supported.

What's supported: Products

Capabilities

Creating & updating items: Our system will be able to identify which items are new and which already exist in our system. Pricing & Multiple currencies: We will sync a default wholesale and retail price for the default currency only. Additional levels of pricing can be supported through customer-level discounts or price sheets ("price groups" in ApparelMagic). Pricing per size is supported.   Sync parameters: You will be able to select which product groups should be sent to NuORDER. Custom Export Schedule: Using the FTPeek plug-in, you will be able to decide how frequently you wish to export product updates from ApparelMagic, up to hourly.

 

Callouts

Custom fields are not supported at this time. If you have a business requirement that is not covered in the standard setup, please review this with your Integration Manager. Requirements to sync products: UPCs or SKUs are required. If an item in ApparelMagic does not have a UPC/SKU, it will not be synced to NuORDER. Product Type = P (i.e. components will not be synced). Product Type P products will export from Apparel Magic. "Attribute 3" / Key Identifiers: In NuORDER, the key identifiers for a unique product are Season + Style Number + Color. In ApparelMagic, you also have "Attribute 3". If you are using Attribute 3, you will need to contract Quecentric to customize your integration to concatenate this into one of your key fields (usually Color) to ensure unique records. Price per size is supported. Multiple currencies are not supported. If you sell in multiple currencies, you will need to utilize price sheets ("price groups" in ApparelMagic) to adjust the pricing for different customers. Availability Dates are not included in the product data integration at this time. You can manage these directly in NuORDER if needed. Archiving/disabling products: This is not included in the product data integration at this time and will be managed directly in NuORDER.

 

What's supported: Customers

Capabilities

Creating & updating customers: Our system will be able to identify which customers are new and which already exist in our system. Multiple billing & shipping addresses are supported. Sync parameters: Your NuORDER export will include all "active" customers from ApparelMagic. Custom Export Schedule: Using the FTPeek plug-in, you will be able to decide how frequently you wish to export customer data updates from ApparelMagic, up to hourly.

 

Callouts

Buyer data (name, email address, sales rep assignment) is not included in the customer data interface and must be managed directly within the NuORDER app. Custom fields are not included at this time. If you have a business requirement that is not covered in the standard setup, please review this with your Integration Manager. Two-way customer sync is not supported at this time. Your customers must originate in ApparelMagic Desktop and be synced to NuORDER with all the necessary account codes. (This is how ApparelMagic Desktop will recognize the customer when the order is synced back in.) Process for New Customers: When working with a new customer in NuORDER, you will need to save the order as a DRAFT. Your team will need to add the new customer record into ApparelMagic first. The customer will be sent into NuORDER on the next run. Once the customer is visible in NuORDER, the sales rep can open their draft, select the customer, fill in the buyer's name and email address, and submit the official order. Archiving (deactivating) customers: This is not included in the ApparelMagic interface at this time and must be managed directly in NuORDER.

 

What's supported: Inventory

Capabilities

Immediate quantities: By default, our script will pull from the "Available to Allocate" bucket in ApparelMagic.  WIP (work-in-progress) inventory is supported. ApparelMagic will pull the PO date for NuORDER for future quantities. If multiple POs exist with the same date & SKU, the quantities will be combined for NuORDER.  Warehouses: Multiple warehouses are supported.  Make sure your warehouses are defined and populated with stock in ApparelMagic prior to starting the NuORDER integration. You will also need to set up the warehouses in NuORDER prior to uploading your data. (Go to Admin > Brand Settings.) Custom Export Schedule: Using the FTPeek plug-in, you will be able to decide how frequently you wish to export inventory data from ApparelMagic, up to hourly.

 

Callouts

Prebooking: For items that should have unlimited quantity available in NuORDER, you will control this directly in NuORDER via the Admin section. Rules can be based on any product attributes, and you will have direct access to control and update the rules as needed.

 

What's supported: Orders

Capabilities

Parameters: You will have the option to send Approved, Pending, or In Review orders from NuORDER to ApparelMagic. (Most brands do Approved orders only.) Custom Import Schedule: Using the FTPeek plug-in, you will be able to decide how frequently you wish to import orders into ApparelMagic, up to hourly. You can also "Fetch Orders" from the FTP on demand. Order fulfillment process: Once the order has been synced to ApparelMagic, your team will take it from there per your normal approval and fulfillment process.

 

Callouts

Custom fields are not supported at this time. If you have a business requirement that is not covered in the standard setup, please review this with your Integration Manager. Order Import Failures: When we send the orders to ApparelMagic, we provide the  ApparelMagic customer code as well as the product UPCs. If any of these values are not recognized in ApparelMagic (e.g. if there was a typo, or the record has been altered in the ERP), the order will fail to import. If this happens, you will need to review the order and resolve the issue. Editing or Canceling orders: After the order has been imported into ApparelMagic, any further changes must be done directly in ApparelMagic.