Tag: csv import

Excel Functions Used In CSV Import

We have to use various excel functions for importing such as Text functions ,Lookup functions ,Date and Time functions, If and related functions etc Note: In Excel we can use FORMULATEXT() function to know the functions that we have used in each cells. a) Right function is used to extracts a given number of characters… Continue reading Excel Functions Used In CSV Import

Product CSV import in magento2

Magento supports different CSV imports such as product, customer address, additional prices etc. Logged in to Magento backend and navigate to System->Data Transfer->import Select the entity type, and choose the import behaviour such as add or update / replace method.Add the file to import.Resolve the issues while import csv and verify the csv file. Thank… Continue reading Product CSV import in magento2

Imports options

ADD – Select if all imported records are new to NetSuite. UPDATE – Select if all imported records already exist in NetSuite, and the import is intended to modify these records. ADD OR UPDATE – Select if imported records are a mixture of new and existing records. Under Advanced Options: If Validate Mandatory Custom Fields checkbox is checked,… Continue reading Imports options

Error_This record already exists

The error occurs during CSV import when we use an external ID that was already used. We can create a saved search to see if an external ID is already used in the system. How to resolveImport the record using a new external ID

Error_ Invalid price plan reference key CUA2A for Currency 1.

This error occurs when we import subscriptions.This error is usually returned when the Price Plan that is being used for a new Subscription has already been used in an existing Subscription. We can check whether the price plans that we imported are already used, by creating a saved search.How to resolve Create a new Price… Continue reading Error_ Invalid price plan reference key CUA2A for Currency 1.

CSV Import to add Bank Details for VENDORS

Before users can import Entity Bank Details, Vendor records which will be updated need to have the EFT Bill Payment checkbox enabled under Bank Payment Details subtab. This can be done via CSV Import or Mass Update. After updating this field, users can now do a CSV Import for the Custom Record called Entity Bank… Continue reading CSV Import to add Bank Details for VENDORS

Kit Item CSV Import

Use the following steps to import Kit/Package Item record via CSV Import. You can perform this action in two ways Import using Single File Import Using Multiple files If you are importing using a single fileIn this scenario, we have to provide the mandatory fields ITEM NAME, the INTERNAL ID of the Member Item, Quantity,… Continue reading Kit Item CSV Import