Importing Products
Similar to importing Business Partners, this procedure also involves four steps, which are outlined in the subsequent sections.:
Creating the Product Import Loader Format
In the Import Loader Format window, we add and save the following information on the Import Format tab:
Set the Organization field to *.
Set the Name field to Import Product.
Set the Table field to I_Product (shown as I_Product_Import Product in the option).
Set the Format field to Comma Separated.
Next, we proceed to the Format Field tab. The I_Product table contains 50 columns that can be used to construct an import structure. The available column option can be found in the Column tab.
For the purposes of our example of importing Products, we will use the nine most commonly-used columns. We can add and save the following information:
|
Field\Data |
1st data |
2nd data |
3rd data |
4th data |
5th data |
|---|---|---|---|---|---|
|
Sequence |
10 |
20 |
30 |
40 |
50 |
|
Name |
Search Key |
Name |
Category ID |
Product Type |
List Price |
|
Column |
Value_Search... |
