{"id":976,"date":"2016-09-16T06:28:18","date_gmt":"2016-09-16T06:28:18","guid":{"rendered":"https:\/\/www.onsightapp.com\/user-guide\/?p=976"},"modified":"2025-09-08T18:35:23","modified_gmt":"2025-09-08T18:35:23","slug":"how-do-i-bulk-upload-customer-product-availability","status":"publish","type":"post","link":"https:\/\/www.onsightapp.com\/user-guide\/how-do-i-bulk-upload-customer-product-availability\/","title":{"rendered":"How do I bulk upload product availability per customer?"},"content":{"rendered":"<p>The Onsight web console provides an easy way to bulk upload your per-customer product availability information without having to update and import all of the other product info. Only your customer product availability info will be updated. This way all of your other product info will not have to re-sync to your team&#8217;s mobile devices. To use this tool, your product info, customer group info and customer info must be uploaded already. If you have not yet uploaded all your product info please rather follow the guide on <a href=\"\/user-guide\/bulk-uploading-your-product-catalogue\/\">how to bulk import your products<\/a> instead.<\/p>\n<p>To access the bulk upload tool to upload your per-customer product availability:<\/p>\n<ul>\n<li>Log in to the Onsight web console at\u00a0<a href=\"https:\/\/sales.onsightapp.com\/\" target=\"_blank\" rel=\"noopener\">https:\/\/sales.onsightapp.com<\/a>.<\/li>\n<li>Click on \u2018Import &#038; export data\u2019 from the left-hand side menu.<\/li>\n<li>Click on the &#8216;Products + Groups&#8217; menu item.<\/li>\n<li>Click on &#8216;Group availability&#8217;<\/li>\n<li>This will open up the 4-step\u00a0product group availability import &#038; export tool.<\/li>\n<\/ul>\n<h2>Step 1: Export the product group availability data<\/h2>\n<p>Click the &#8220;Download&#8221; button and save the the product group availability data sheet somewhere you will find it easily. Once done, click on \u2018Continue\u2019. <\/p>\n<h2>Step 2: Change the product group availability data<\/h2>\n<p>Open the spreadsheet file. Each row in your spreadsheet represents one of your products. Each column contains a different customer group. Edit the cells to change the product availability required for each customer group. <\/p>\n<h2>Step 3:  Upload the new product group availability data<\/h2>\n<p>Save your file. Click on the \u2018+\u2019 button and select your saved data sheet on your computer. Once done, click on \u2018Continue\u2019.<\/p>\n<h2>Step 4: Import the new product group availability data<\/h2>\n<p>Click the \u2018Import\u2019 button to start the import process. Your data sheet will be analysed and validated. Once the import job progress is at 100%, click on either:<\/p>\n<p>\u2018For review &#8211; view and approve this job\u2019.  If your data sheet passes validation, you will see a list of updates that will be applied once you approve the import job. If everything is correct, click \u2018Approve Job\u2019 and your data will be imported into the database.<\/p>\n<p>or <\/p>\n<p>\u2018Failed &#8211; view the job\u2019. If the data sheet fails validation, a list of errors will appear, which you must correct before uploading it again.  Click on \u2018Cancel Job\u2019 and correct the data in your upload data sheet and then start at Step 3 again. <\/p>\n<h2>Check on your import jobs<\/h2>\n<p>If you navigate away from the import process whilst it is running, you can come back later to check on the progress. To see the status of all your import jobs, go to &#8216;Import &#038; export data&#8217;  &gt; &#8216;Import jobs&#8217; and you will see them all listed. Click on the file name to see the detailed progress. <\/p>\n<h2>Data volume limits<\/h2>\n<p>On the Business plan, you can have a maximum of 5,000 products and up to 100 customer groups. Each combination of a product record and a customer group record generates a new availability record. The combination of products and customer groups is limited to 320,000 availability records.<\/p>\n<p>For example:<\/p>\n<ul>\n<li>If you have 5,000 products, you can have a maximum of 64 customer groups (5,000 \u00d7 64 = 320,000).\n<li>If you have 100 customer groups, you can have a maximum of 3,200 products (100 \u00d7 3,200 = 320,000).\n<\/ul>\n<p>These limits do not apply if your Onsight account is connected to an ERP system \/ accounting system, as all the product availability data in your external system will automatically sync to Onsight.<\/p>\n<h2>Still have questions?<\/h2>\n<p>If you are still uncertain of how to proceed or if you encounter any problems email us at <a href=\"mailto:support@onsightapp.com\">support@onsightapp.com<\/a> and we will help you through the process step-by-step.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Onsight web console provides an easy way to bulk upload your per-customer product availability information without having to update and import all of the other product info. Only your customer product availability info will be updated. This way all<span class=\"ellipsis\">&hellip;<\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,7],"tags":[],"_links":{"self":[{"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/posts\/976"}],"collection":[{"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/comments?post=976"}],"version-history":[{"count":9,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/posts\/976\/revisions"}],"predecessor-version":[{"id":4471,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/posts\/976\/revisions\/4471"}],"wp:attachment":[{"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/media?parent=976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/categories?post=976"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/tags?post=976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}