Account Product Prices and Restrictions

Importing Account Prices and Restrictions via Data Mapper.

📘

It is recommended to set up a Dropbox or FTP folder named: Account Prices And Permissions with a sub folder called Archived.

The file names can be anything, but if you plan to import one file per account, please set the file name to something like account_name_yyyymmdd_hhmm.csvIf importing for multiple accounts in one file, you can name it something like account_products_and_prices___%dd_%mm_%yyyy.csv

When processed, Zoey will add the process timestamp and the Archive folder will be easy to audit.

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 like this:

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.