Account Product Prices and Restrictions

Importing Account Prices and Restrictions via Data Mapper.

Mapper Settings

1. Set up your Data Mapper's basic Configuration. Provide the Name, choose a Connection, and set up your Schedule. This can be done after setting up the mapper.
2. Select Account Prices and Restrictions from the Zoey Object drop-down.
3. Set Type to File Import.
4. Import Mode should be set to Import Based On File Name.
5. Select Custom Account Prices And Restrictions Import from the Mapper Template.

Field Mapping

The template is mapped to Assign the SKU and Price to the Account using the Account Name and/or the Account ID.

Your file should look similar to this example:

Account Product Prices and Restrictions CSV example:

Things to note:

• The import will support account_id (zoey Account ID) or Account Name as the identifier.
• The import will support one or multiple accounts at the same time
• account_price rows can be left blank and the price for those SKUs will fallback to the customer group or product price.
• Setting account_price to 0 will set the price to $0.00. To remove a previous price from an account, leave the price blank.
• account_restricted is 1 = allow, 0 = not allowed - our database only stores allowed, so setting 0 will do nothing unless the product was previously allowed, then it will remove it from the account.
• The account_product_restriction_type value is set at the account level, so each row for the same account should have the same number so the account's Behavior For Product Restrictions is set properly.

  📘

  In the example, both rows for Test Account 1 are blank so that the Account uses the system default restriction behavior, and both rows for Test Account 2 use 2 so that account will only see the specific products restricted to them.

Changing the Behavior For Product Restrictions on an Account

The behavior setting that controls how an Account's product restrictions function can be controlled through Account CSV import.

Under the account_product_restriction_type column set the restrictions behavior through the options listed in the table below. Blank, 0, 1, and 2 are accepted for the import column.