Imports

Imports is the tool for creating, maintaining and updating your Macola database. Manipulate data using your favorite spreadsheet such as Microsoft Excel or Google Sheets, save new or updated information as a comma separated file (CSV), and import the information with one click.

Import sample files with complete documentation:

Features:

• Import new data or update existing data (*)
• Manage data in the format best for you and import as a CSV
• Import and update Macola with 1 click (*)
• Imports comes with over 30 different imports!
• Ability to automate with Job Master
  • Setup a directory
  • Point the import job at the directory
  • Drop a properly formatted file in the directory
  • Seconds later the data is automatically imported into your system

Supported Imports:

• Inventory
  
  • Import Items
  • Import Item Locations
  • Import Item Files
  • Import Item Location List Price from Vendor Number and Vendor Item Number
  • Import Cube Diensions
• Bill of Material (BOM)
  • Import Product Structure
• Order Entry
  • Import Price Codes
• Ecommerce
  • Import Web Pages
  • Import Users
  • Import Roles to Users
  • Import Web Item Information
  • Import Items To Web Pages
  • Import Cross Sell Items
  • Import Up Sell Items
  • Import Permissions
  • Import Audiences
  • Import Items to Audiences
  • Import IP Address Range Information
  • Import Yahoo Store information
• General Ledger
  • Import G/L Accounts (Macola Progression only)
  • Import G/L Budgets (Macola Progression only)
• Accounts Payable
  • Import Vendors
  • Import Vendor Items
  • Import A/P Open Items (Macola Progression only, only supports creation)
• Accounts Receivable
  • Import Customers
  • Import Ship Tos
  • Import Customer Items
  • Import A/R Open Items (Macola Progression only)
  • Import Tax Codes
  • Import Tax Schedules
• BRAIN Contact Relationship Manager (CRM)
  • Import Contacts
•  Other
  • Import Credit Card Authorizations
  • Import Fields
  • Import Coupons
  • Import Custom CSV - Allows you to create a custom table from a CSV file

* Note - Not all import types support both Creation and Update. Imports support Macola Progression, Macola ES, and Macola EM 10 unless otherwise noted.