CSV Import Extension in SCA

CSV Import functionality is implemented in the Cart page of the website, particularly under the Quick Add section. The user visits the shopping cart page, which has the quick add functionality on it. click the input button and select a file from their computer. The system will validate the file and show the validated information (Error data and validated data) in the pop-up view. Item can be added to the cart by clicking the Proceed button. This will take a little bit of time depends upon the no of valid items that the user plotted inside the CSV. The popup window also contains the invalid data plotted by the user(if any) and the items may have failed to add to cart(based on the stock availability and minimum quantity requirement). So if the user needs to re-upload the file, just click the Exit button and upload it again.

SYSTEM REQUIREMENTS

  1. Products Id should map to external Id in NetSuite.

This can be achieved by a map-reduce script and workflow/Workflow action script.

      2.  This extension is applicable for only inventory items.

USER LEVEL REQUIREMENTS 

  1. Users should upload the CSV file which contains 2 column productid and quantity.

A maximum of 100 items can be added using CSV Export at a time.

Leave a comment

Your email address will not be published. Required fields are marked *