Products - Import from NetSuite

NetSuite to Zoey Product Import

  • Import Product Data from NetSuite
    When set to Yes, products will be synced from NetSuite to Zoey.
  • Enable Automatic Product Import
    When enabled, product data will be synced from NetSuite to Zoey twice an hour.
  • NetSuite Product ID Attribute
    Select the Zoey Product Attribute that will contain the internal NetSuite ID for each product.
  • NetSuite Product Type Attribute
    Select the Zoey Product Attribute that will contain the NetSuite Product Type.
  • Import Product Status from NetSuite
    When set to Yes, Zoey products can be enabled or disabled based on the products data in NetSuite.
    • NetSuite Item Status Source
      This is NetSuite Item field used to determine Zoey Product Status. This field must be a boolean. isInactive (boolean) is normally used.
    • Zoey Product is Disabled when...
      Specify when the Zoey Product should be disabled based on the status source value.

Inventory Settings

  • Import Product Inventory from NetSuite
    When set to Yes product inventory will be synced from NetSuite
    • Prevent Inventory Sync Attribute
      Select a Zoey Yes/No attribute to be used as a flag to prevent syncing inventory from NetSuite. When this attribute is set to Yes on a product, its inventory will not be synced from NetSuite.
  • Allow Inventory Import from Different Item
    When enabled, specify the attribute to use for a separate NetSuite Item ID to sync inventory. If this attribute is set on a Zoey Product it will sync inventory from the specified Item instead of the Item the Product is linked to.
    • Different Inventory Item Attribute
      The Zoey product attribute that will be used to indicate to import inventory from a different Item.
  • Quantity Field for Inventory
    Select the NetSuite field to pull Inventory from. This let's you whether quantityOnHand or quantityAvailable is used to update the product inventory in Zoey.
  • Limit Inventory to Specific Locations
    Only specified Inventory Locations will be used to calculate available inventory.
    • Locations
      Only the selected locations will be used for calculating product inventory.
  • Enable Location Mapping
    When set to Yes, you can then map NetSuite Locations to Zoey Inventory Locations.
📘

Don't see an option that you're expecting? Go to Record Caching and click on Refresh Record Cache.


Price Settings

  • Import Prices
    When set to Yes, price information will be imported from NetSuite
    • Import Customer Group Prices
      When set to Yes, Customer Group prices will be imported based on the NetSuite Price Levels, unless Use Product Pricing Groups is set to Yes.
    • Multi-Currency Support
      Set to Yes if your NetSuite environment uses multiple currencies.
      📘

      The NetSuite API Role used for this Integration must have Permission Lists > Currency with a level of View to use this feature.

    • Import Tier Prices
      When set to Yes, Tier Prices for order item amounts will be imported from NetSuite.
      • Import Tier Prices for ALL GROUPS
        When set to Yes, Tier Price information will always be imported for All Customer Groups instead of per Customer Group Price Level.
    • Import Product Cost from NetSuite
      When set to Yes, product costs will be imported from NetSuite.
    • Price Import Logic
      Set the logic for importing prices from NetSuite:
      1. Highest Price Level
      2. Lowest Price Level
      3. First Price Level
      4. Specific Price Level
        📘

        When using Specific Price Level, you can select the NetSuite Price Level to import.


Product Import Field Mapper

  • Zoey Field
    Select the Zoey field you want to sync with a field in NetSuite.
  • NetSuite Field
    Select the NetSuite field to map to the field you selected for the Zoey Field.
  • Additional Field (Button)
    Add as many additional Product field mappings as needed.

Import Product Images from NetSuite

The storeDisplayImage (RecordRef) field can be mapped from NetSuite to the Zoey Base Image (image | 85) to import the product's image into Zoey.

🚧

Commas and Parenthesis in the image file's name will prevent it from being imported to Zoey.