ApparelMagic Desktop Integration: Overview & What to Expect

This article is for APPARELMAGIC DESKTOP. If you are using APPARELMAGIC CLOUD, click here.


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.

The flow of data includes:

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


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. 


Turnaround Time

The average ApparelMagic integration will take approximately 8-10 weeks from the project kickoff to completion. This does not mean we'll be spending 8-10 weeks writing code, but rather this is the complete time to get through all stages of the rollout. The part of the process that takes the most time is prepping your ApparelMagic Desktop data for the integration. Once this is complete, testing and final review should only take a couple weeks.

  • Planning and discovery sessions
  • Any preparation on your side to get your ApparelMagic data cleaned up and ready for integration
  • Testing and review in the NuORDER sandbox
  • Adjustments
  • Final review and sign-off
  • Transfer from sandbox to production 
  • Post-launch validation


Who's Involved From Your Team

  • Your ApparelMagic Administrator, or someone technical who is familiar with your specific ApparelMagic setup.
  • Sales or Operations Manager who understands your business, how it is structured and how the reps sell. 

What you'll be doing:

  • Answering questions about your specific ApparelMagic setup and sales process.
  • In some cases, you might need to make some bulk adjustments (e.g. adding a field or editing for consistency) to your data in ApparelMagic so that we can achieve the best possible experience for your users in NuORDER.
  • Reviewing your data in the NuORDER sandbox and providing feedback.
  • Reviewing test orders in ApparelMagic and providing feedback.
  • Reviewing and validating again as any adjustments are made to the feeds.
  • Providing the final sign-off to go live.
  • Reviewing the data feeds day-to-day after you go live to make sure everything is looking correct.
  • Working with us to address any issues that may arise once your team is using NuORDER in the live sales environment.


Who's Involved From the NuORDER Team:

  • An Integration Manager who will be your day-to-day point person, manage the project and guide you through the rollout from start to finish.
  • A Third Party Integration Engineer who will configure your ApparelMagic account to import & export the data feeds for NuORDER. We have contracted a third party called QueCentric to work with us on the back-end setup. If you need any customization from the standard set-up, QueCentric can provide this support for a fee.

What we'll be doing:

  • Asking questions about your specific ApparelMagic setup and sales process.
  • Configuring the data files to import & export based on your specific business rules.
  • Exporting test data into the NuORDER sandbox.
  • Exporting test orders into ApparelMagic.
  • Making sure your team is updated throughout the process and addressing delays that might occur on either side.


What's Supported: Products


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. 



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


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.  



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


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. 



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


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.




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.  



Was this article helpful?
0 out of 1 found this helpful
Have more questions? Submit a request