New configuration – Creation and updating of products
Reach the section for creating a new Configuration, following the path Menu > Catalogs > Personal Data and click on the " New Configuration " button at the top right .
Creation of new configuration
The creation will be divided into 4 steps:
Loading information
Information mapping
Filter products
Save
1 Loading information
In this section it will be possible to enter useful information for reading the csv file.
Indicate the source of the file:
FILE – Loading a local file (from your PC)
HTTP – Enter the URL from which to retrieve the file (e.g. http or https://…)
FTP – Enter the access credentials for the FTP folder and the file path
SFTP – Enter the access credentials for the SFTP folder and the file path
Indicate the file scheme:
Activate the “File contains header row” switch if the first line in the file indicates the name of the data contained in the corresponding columns
Indicate the column separator used when saving the file.
Enable/disable text separator and indicate the separator used when saving the file.
To learn more about the formatting and structure of the CSV file to use for uploading and updating products, go to this guide .
Once you have inserted the file and indicated the scheme for correct reading, click on the " Analyze " button at the bottom right. You will be taken directly to the next stage.
2 Information mapping
Poleepo, thanks to the instructions received in the previous phase, will be able to analyze the file and offer a preview of the information contained in it.
Verify that the columns and products identified correspond to the real information in the original file.
Preliminary information
Indicate in this section what type of operation you want to perform:
Upload new products – Operation of creating new products with the information contained in the file.
To learn about the structure of the file and the mandatory information for creating products go to this guide .
– Update an existing product – By activating this switch in phase of uploading new products, if the file contains a product already uploaded to the platform, this will be updated with the new information.
Updating products – Operation for updating products already present on the platform.
To find out the structure of the file and the mandatory information for creating products, go to this guide .
1. Supply
Indicates the supply of the products contained in the file you are uploading.
You can select from the drop-down menu whether to create or update the products for the internal warehouse or for an external supplier. If you have not previously created the supplier you want to associate the products with, click on “Add a Supplier”.
To learn more about vendor creation and management, go to this guide.
2. Identifiers
Internal Warehouse Identifier
Upload new products – For this type of operation, the SKU, EAN, UPC (if not ISBN) and MPN fields, will be populated with the information contained in the file.
Remember that, in the event that the SKU field is empty, Poleepo will assign its SKU to each product.Update products – In this type of operation, SKU, EAN, UPC (any ISBN) and MPN fields will be used as a product identification key. A hierarchical scale of use will be used as follows:
SKU – If present it will be the first entry to be taken into account.
EAN – Second entry by hierarchy. If present in conjunction with the sku, it will be updated.
UPC (Third voice in importance)
ISBN (if you sell books)
MPN – Last voice in importance. If present in conjunction with both or one of the previous two entries, it will be updated.
Identifier External Provider
If you have indicated in the “Supply” field an external supplier, there will be an additional field called “SUPplier SKU”. Indicates in this field the column containing the supplier code.
Upload new products – For this type of operation, SKU, EAN, UPC MPN and SKU Supplier fields will be populated with the information in the file.
Remember that, in the event that the SKU field is empty, Poleepo will assign its SKU to each product.Update products – In this type of operation, SKU, EAN, UPC MPN and supplier code fields will be used as a product identification key. A hierarchical scale of use will be used as follows:
SKU – If present it will be the first entry to be taken into account.
EAN – Second entry by hierarchy. If present in conjunction with the sku, it will be updated.
UPC Third voice by hierarchy. If present in conjunction with both or one of the previous two entries, it will be updated.
ISBN- Fourth item in importance (if the product falls into the book category)
MPN – Last voice in importance. If present in conjunction with all or one of the previous entries, it will be updated.
3. Information
Name
Description
Long description
Mark
Weight
Height
Length
Depth
4. Category and images
Category(s)
Path Categories Separator (indicates the separator to use if there are multiple categories in the same column)
Main and secondary image
Tags
5. Position
Deposit
Area
Shelf
Plan
Hole
Packing height in Cm
Packing width in Cm
Depth packing in Cm
6. Quantity
select the corresponding column in the file
decide the Stock behavior on existing products (whether to overwrite the quantity, add the quantities or subtract the stock)
stock behavior on products already present on the platform but not present in the update (do not modify the stock of the products or set the stock of the products to 0)
7. Prices
sale price (excluding taxes)
purchase price (excluding taxes)
Reload percentage (Percentage on Non-Vate Purchase Price)
Taxes with VAT
Discount Percentage (Percentage on the Sale Price)
Discounted Sale Price (Tax included)
Sale Price (Tax included)
8. Features
Select a feature
9. Variants
Product SKU to add the variant to (you can indicate if it is a supplier SKU
attributes and attribute name
10. GPSR
GPSR Information: (Responsible, manufacturer, safety attestation, CE marked images, Additional image, safety information, installation manual)
Mapping information from csv files.
Once the information for identifying the products has been set, you will need to proceed with the mapping of the information contained in the file for the creation or updating of the products.
Single products
Upload new products
For each field, indicate the column of the file containing the requested information.
Skip the mapping of the “Variants” section.
Proceed to the next step by clicking on the “ Next ” button.
To find out the mandatory information for creating new single products, go to this guide .
Update products
Indicate a discovery key and all fields to update.
Move to the next step by clicking on the “ Next ” button.
Products with variations
Upload new products
For each field, indicate the column of the file containing the requested information.
In the "Variants" section, map the columns containing information relating to the product variants.
Do not enable the “It's a Vendor Sku” switch.
Proceed to the next step by clicking on the “ Next ” button.
To learn the mandatory information and structure needed for creating new products with variations, go to this guide .
Update products
Indicate an identification key relating to the variant and all the fields to update.
Move to the next step by clicking on the “ Next ” button.
Single products / with variants associated with an external supplier
To carry out operations on an external supplier, in the " Supply " section, a supplier must be selected.
Upload new products
For each field, indicate the column of the file containing the requested information.
If the product has variants, in the "Variants" section map the columns containing information relating to the product variants, otherwise ignore the "Variants" sections
If you are creating products with variants that have a "parent sku" provided by the supplier, activate the "It is a supplier Sku" switch, so as to create an external supply directly on the variant.
Remember that the purchase prices and quantities will be added as a supply identified by the name of the chosen supplier, in the prices and stocks section.
Proceed to the next step by clicking on the “ Next ” button.
To learn the mandatory information and structure needed for creating new products with variations, go to this guide .
Update products
Indicate an identification key relating to the variant and all the fields to update.
Remember that the purchase prices and quantities will be updated to the supply identified, in the prices and stocks section.
By entering the product sku as an identification key, if the supply is not yet present, it will be created and updated with the information present in the file.
Move to the next step by clicking on the “ Next ” button.
3 Filter Products
In this section it will be possible to filter the products contained in the file on which to perform the previously chosen operation.
Select operation:
Do not filter – To import or update all products contained in the file
Include – To import or update all products that fall within the established criteria (Warning: the products will then be included through the data entered! The products that comply with all the filters indicated will be examined)
Exclude – To import or update all products that DO NOT FALL UNDER the established criteria (Warning: the products will then be excluded by discarded through the data entered!)
Search criteria:
Brand
Category
Weight (from n.Kg to n.Kg)
Purchase Price
Sale price
Quantity
Move to the next step by clicking on the “ Next ” button.
4 Save
Last step of creating a new configuration.
Enter a name that can briefly describe the type of operation you want to do with this configuration.
Click on save.
Conclusions
Once you have followed the entire procedure for creating a new configuration, following the path Menu > Catalogs > Master Data , you will be able to view the saved configurations and carry out operations on them. To learn how to perform a saved configuration go to this guide .