Version: eXtendPS-DE 1.4 and above
Audience: Administrator, User

Use Case

  • Constituting vendor items in bulk through PromoStandards

Summary 

eXtendPS-DE allows you to create items in bulk using a CSV/Excel sheet. This feature can speed up the process of creating multiple items at once. It also enables the creation of all available product variants (such as sizes and colors) to quickly create these as matrix items.

Using Bulk Item Constitution

Creating the CSV/Excel Sheet

Create a CSV or Excel sheet with a ProductId list and their respective Vendor:
  1. ProductId
    Specify the item style.
  2. Vendor
    Specify the vendor name as listed in your NetSuite account.
    This is case sensitive and must match the exact display as shown on the vendor record in NetSuite.
  3. Category
    Specify the internal id of the category. If you want to use a text value instead of id, set the column header as CategoryText.
  4. Category2
    Specify the internal id of catgory2. If you want to use a text value instead of id, set the column header as Category2Text. 

  • ProductId and Vendor are required fields.
  • Category and Category 2 are optional fields.
  • Column headers are case sensitive and need to be specified exactly as shown here.
Note:
This process does not support specific color/size combinations. All items' colors and sizes will be created when using this method.

Sample import file format:
                           Image Placeholder

CSV/Excel Sheet Upload

  1. Once the CSV/Excel sheet has been created, open the eXtendPS-DE Bulk Item Constitute page.
  2. Drag and drop the file or select it from your files.
  3. Up successful upload, you will receive the following message:
    Your file (XXXXXXX.xlsx) has been submitted successfully. You will be notified via email upon completion. Log id for your uploaded file is 000000.
    Image Placeholder
  4. You can view details of the bulk item constitution process by viewing the eXtendTech Logs record referenced from the log file id.Image Placeholder
  5. If all the eXtendPS-DE Bulk Item Constitution Map/Reduce script deployments are engaged, you will receive the following error message. In such cases, please wait until one of the prior script executions is complete before initiating a new request. 
    Image Placeholder
  6. If there are data or formatting issues in the CSV/Excel sheet, you will receive a validation error message. Once you correct the data or formatting issues, you can process the upload again.Image Placeholder
  7. If no response is received from the supplier's PromoStandards service, or if the item already exists in your account, this will be noted in the email that you receive after processing has completed.

Bulk Item Constitution Best Practices

We recommend constituting at least two items and verifying field mappings are correct before constituting items in bulk.

To avoid timeout errors, limit the import size to 100 products or styles at a time.

Many PromoStandards suppliers apply rate limiting to their endpoints. As a best practice, you should contact your supplier to inform them that you will be constituting a large number of items from their catalog into your system before beginning.

Configuring Bulk Item Constitution

To enable the bulk item constitution feature, ensure that the "eXtendPS-DE Bulk Item Constitute" script deployment has been created against the eXtendPS-DE Suitelet.

If the deployment does not exist, you can create one using these steps:
  1. Go to Customization → Scripting → Scripts.
  2. Find the script file titled eXtendPS-DE Suitelet and view it.
  3. Create a new script deployment with the following configuration:
    1. Set the Title as eXtendPS-DE Bulk Item Constitute.
    2. Set the ID as customdeploy_extend_promo_bulk_item_cons

      Note: the ID of this script deployment must be customdeploy_extend_promo_bulk_item_cons
    3. On the Parameters subtab, set the Deployment Type as bulkConstitution
  4. After the script deployment has been created, click the URL field shown in the screenshot above to open CSV/Excel file upload page.

  5. Optionally, you can add a link for this script deployment to custom categories or center tabs as per your requirements to allow quick access.