{"id":206,"date":"2021-08-19T13:12:26","date_gmt":"2021-08-19T12:12:26","guid":{"rendered":"https:\/\/ecommercepreston.co.uk\/?post_type=ht_kb&p=206"},"modified":"2021-11-05T15:25:53","modified_gmt":"2021-11-05T15:25:53","slug":"importing-a-price-list","status":"publish","type":"ht_kb","link":"https:\/\/ibridge.co.uk\/help\/knowledge-base\/importing-a-price-list\/","title":{"rendered":"Importing a Price List"},"content":{"rendered":"

After creating the Pricelist, There are 2 methods of adding data to a Pricelist…<\/p>\n

Method 1: Importing your Exported XLS File<\/strong><\/h3>\n

After we have Exported the Pricelist to an XLS format, we can modify it and re-import it.\u00a0Please only change the PricelistNetPrice<\/strong><\/em> field for the line you are changing. And also ensure that for each Product Price line you are adding that there is a ProductId<\/strong><\/em>, SKU<\/strong><\/em> and PricelistNetPrice. <\/strong><\/em>These 3 fields are all required for line of the XLS file you add. Please make sure you have added them before importing.<\/p>\n

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

Method 2: Importing Using a Template<\/strong><\/h3>\n

You can use this template (PricelistTemplate.xlsx<\/a>) which is an empty version of the example image above. Within this you must ensure you add a ProductId<\/strong><\/em>, SKU<\/strong><\/em> and PricelistNetPrice<\/strong><\/em> for each row you want to define a Product Price for. If you haven’t defined at least these fields for a Product then it will not be able to Import the XLS.<\/p>\n

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

 <\/p>\n

PLEASE BE AWARE!!!<\/u><\/em><\/p>\n

Pricelist Net Price must always be lower than the Product Net Price. Please ensure this is the case. In addition, you will also need to frequently check the Pricelist Net Price when you change a Products Net Price.<\/em><\/p>\n<\/div>\n

Importing the XLS File<\/strong><\/h2>\n

Once you have an XLS file ready to import.<\/p>\n

Navigate to\u00a0BoB2 \u2192 Customers\u2192 Bob Customer Price Lists<\/strong><\/em><\/p>\n

And find the Price List from the List you want to import to. Then press the “Edit” button adjacent to the row of the Price List.<\/p>\n

\"\"<\/p>\n

You will now be in the Price List view screen where you will see a button at the top called “Import”, press the “Import” button in the upper right-hand corner. This will display a window where you can insert the XLS you have configured. Then press \u201cImport\u201d.<\/p>\n

\n
\"\"<\/a><\/div>\n<\/div>\n

Confirming Import<\/strong><\/h2>\n

You will then be asked to confirm the Import. (Note: You can only import, when there are no errors with the data). The Pricelist Import is looking for 3 different fields, ProductId<\/strong><\/em>, SKU<\/strong><\/em> and PricelistNetPrice<\/strong><\/em>. Please ensure you have entered all 3 per XLS row otherwise it will not allow an Import.<\/p>\n

\n
\"\"<\/a><\/div>\n<\/div>\n
\n
<\/div>\n<\/div>\n

\"\"<\/a><\/p>\n

Price List Validation<\/h2>\n

Once “Confirmed”, you will see the grid below for the Price List has been updated with the new Prices. Please ensure these are correct before setting the Price List as Live.<\/p>\n

\"\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

After creating the Pricelist, There are 2 methods of adding data to a Pricelist… Method 1: Importing your Exported XLS File After we have Exported the Pricelist to an XLS format, we can modify it and re-import it.\u00a0Please only change the PricelistNetPrice field for the line you are changing. And…<\/p>\n","protected":false},"author":1,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"ht-kb-category":[31],"ht-kb-tag":[],"class_list":["post-206","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-price-lists"],"_links":{"self":[{"href":"https:\/\/ibridge.co.uk\/help\/wp-json\/wp\/v2\/ht-kb\/206","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibridge.co.uk\/help\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/ibridge.co.uk\/help\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/ibridge.co.uk\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ibridge.co.uk\/help\/wp-json\/wp\/v2\/comments?post=206"}],"version-history":[{"count":8,"href":"https:\/\/ibridge.co.uk\/help\/wp-json\/wp\/v2\/ht-kb\/206\/revisions"}],"predecessor-version":[{"id":628,"href":"https:\/\/ibridge.co.uk\/help\/wp-json\/wp\/v2\/ht-kb\/206\/revisions\/628"}],"wp:attachment":[{"href":"https:\/\/ibridge.co.uk\/help\/wp-json\/wp\/v2\/media?parent=206"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/ibridge.co.uk\/help\/wp-json\/wp\/v2\/ht-kb-category?post=206"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/ibridge.co.uk\/help\/wp-json\/wp\/v2\/ht-kb-tag?post=206"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}