{"id":21120,"date":"2024-07-22T07:18:47","date_gmt":"2024-07-22T07:18:47","guid":{"rendered":"https:\/\/docs.daftra.com\/user_manual\/%d8%a7%d8%b3%d8%aa%d9%8a%d8%b1%d8%a7%d8%af-%d9%82%d9%88%d8%a7%d8%a6%d9%85-%d8%a7%d9%84%d8%a3%d8%b3%d8%b9%d8%a7%d8%b1\/"},"modified":"2025-12-29T11:20:10","modified_gmt":"2025-12-29T11:20:10","slug":"importing-price-lists","status":"publish","type":"user_manual","link":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-price-lists\/","title":{"rendered":"Importing Price Lists"},"content":{"rendered":"

[vc_row][vc_column][vc_column_text css=”.vc_custom_1741682329633{margin-left: 200px !important;}”]You can manually add price lists, including the products within them and the product prices for each list. However, you can also save time and effort by uploading price lists and their corresponding product data and prices by importing them from an Excel file.<\/p>\n

In this guide, we’ll review how to prepare the Excel file and how to import price lists from it into the system in moments.[\/vc_column_text][vc_custom_heading text=”Formatting the Excel File for Uploading Product Prices in Price Lists” font_container=”tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2″ use_theme_fonts=”yes” css=”.vc_custom_1723376828918{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: 4px !important;}”][vc_column_text css=”.vc_custom_1741682340716{margin-left: 200px !important;}”]<\/p>\n

\n
\n
\n
\n
\n
\n
\n
\n

Ensure that the Excel file you prepare includes the price lists you want to upload to the system, with the products in each list and the price of each product in every list where it is included.<\/p>\n

\"\"<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n

The Excel file should be in CSV format, as this is the appropriate format for files in English.<\/p><\/blockquote>\n<\/div>\n

[\/vc_column_text][vc_custom_heading text=”How to Import Products into Price Lists” font_container=”tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2″ use_theme_fonts=”yes” css=”.vc_custom_1723379886591{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: 4px !important;}”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text css=”.vc_custom_1767007167400{margin-left: 200px !important;}”]<\/p>\n

\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

Click on “Price Lists<\/strong>” under “Inventory<\/strong>” in the main menu, then click on the arrow next to the “Bulk Update<\/strong>” button, and click on “Import<\/strong>.”<\/p>\n

\"\"<\/p>\n

Select the \u201cComma Separated<\/strong>\u201d option and click on \u201cChoose File<\/strong>\u201d to upload the Excel file from your device.<\/p>\n<\/div>\n<\/div>\n<\/div>\n

\"\"<\/p>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n
\n
\n
\n