{"id":541,"date":"2017-03-06T16:21:48","date_gmt":"2017-03-06T08:21:48","guid":{"rendered":"http:\/\/www.irspossystem.com\/wiki\/2017\/03\/06\/how-to-import-stock-quantity-by-excel\/"},"modified":"2018-09-28T11:31:55","modified_gmt":"2018-09-28T03:31:55","slug":"how-to-import-stock-quantity-by-excel","status":"publish","type":"post","link":"https:\/\/www.irspossystem.com\/wiki\/2017\/03\/06\/how-to-import-stock-quantity-by-excel\/","title":{"rendered":"How to import stock quantity by excel"},"content":{"rendered":"

1. Enter IM_ITEMNO & QUANTITY as column header
\n2. Enter theactual quantity follow by itemno<\/p>\n

\"\"<\/p>\n

3. Select stock adjustment
\n4. Change to actual quantity|
\n5. Select import-excel on more option<\/p>\n

\"\"<\/p>\n

6. Lookup for the excel file location
\n7. Click open<\/p>\n

\"\"<\/p>\n

8. After new balance quantity is update
\n9. Click save<\/p>\n

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

1. Enter IM_ITEMNO & QUANTITY as column header 2. Enter theactual quantity follow by itemno 3. Select stock adjustment 4. Change to actual quantity| 5. Select import-excel on more option 6. Lookup for the excel file location 7. Click open 8. After new balance quantity is update 9. Click save More<\/a><\/p>\n","protected":false},"author":1,"featured_media":537,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[88,98],"class_list":["post-541","post","type-post","status-publish","format-standard","has-post-thumbnail","category-item","tag-actual-quantity","tag-stock"],"_links":{"self":[{"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/posts\/541","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/comments?post=541"}],"version-history":[{"count":2,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/posts\/541\/revisions"}],"predecessor-version":[{"id":800,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/posts\/541\/revisions\/800"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/media\/537"}],"wp:attachment":[{"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/media?parent=541"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/categories?post=541"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/tags?post=541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}