Explain Hybris impex file with syntax and add some sample products into store ?

Hybris Impex file syntax contains the following information:

1) Header row:

  <SQL Operation to perform> <Table name> <Columns> (1 column with preferably a uniqueID>.
   INSERT_UPDATE              Product;    code[unique=true];productname

2) Values that we need to insert in those columns.

 ;603;Microwave
 ;4278;Bag

So these values are for the 2 columns code and productname and the table name is PRODUCT. We use semi-columns to separate the contents in the impex files.

As we don't want to add anything under the Table 'Product', in the values section, we keep it blank and that is why the line for values starts with a semi-column.

Once you have created the impex file, you can place in under yourextension/resources/impex and then go to HAC and do the following:

•Navigate to Platform/Update

•Check only yourextension in Project data settings, then click on Update

This will load your data in the DB.

You can follow this link to get a better understanding:

https://help.hybris.com/6.0.0/hcd/bf72f3439f8a4575b328edcb9236a262.html#loiobf72f3439f8a4575b328edcb9236a262

Thanks,

Manpreet