{"id":10184,"date":"2021-03-02T04:04:00","date_gmt":"2021-03-02T02:04:00","guid":{"rendered":"https:\/\/programsshop.com\/?page_id=10184"},"modified":"2021-03-02T04:10:30","modified_gmt":"2021-03-02T02:10:30","slug":"restore-from-excel","status":"publish","type":"page","link":"https:\/\/programsshop.com\/en\/knowledgebase\/restore-from-excel\/","title":{"rendered":"Import items data from excel file"},"content":{"rendered":"
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Import items data from excel file\n<\/h1>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

With Afaky Accounting Program, you can import items data in a few seconds from Excel files, which relieves you from the trouble of entering items manually and saves you a lot of time and effort.<\/span><\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t

\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t1- From the list of stores, choose the opening balances<\/a>\n\t\t\t\t\t<\/h4>\n\n\t\t\t\t\t

Then this screen will appear for you, then choose the store (1) and then add.<\/p>

\"\u0628\u0631\u0646\u0627\u0645\u062c<\/a><\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

\n\t\t\t\t\t

\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t2- Then this screen appears, click Download from Excel file (1).<\/a>\n\t\t\t\t\t<\/h4>\n\n\t\t\t\t\t

\"\u0628\u0631\u0646\u0627\u0645\u062c<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

\n\t\t\t\t\t

\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t3- Then this screen appears for you, specify the location of the excel file<\/a>\n\t\t\t\t\t<\/h4>\n\n\t\t\t\t\t

\"\u0628\u0631\u0646\u0627\u0645\u062c<\/a>
Which contains the items data by clicking on it (1) and then pressing open (2).<\/p>

\"\u0628\u0631\u0646\u0627\u0645\u062c<\/a><\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

\n\t\t\t\t\t

\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t4- Then this screen appears for you, select a column<\/a>\n\t\t\t\t\t<\/h4>\n\n\t\t\t\t\t

The excel corresponding to each column in the program and leave the non-existent
The two most important columns that should be matched are (Arabic name - English name) (1)<\/p>

\"\u0628\u0631\u0646\u0627\u0645\u062c<\/a><\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

\n\t\t\t\t\t

\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t5- Then this screen appears, press OK<\/a>\n\t\t\t\t\t<\/h4>\n\n\t\t\t\t\t

\"\u0628\u0631\u0646\u0627\u0645\u062c<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

\n\t\t\t\t\t

\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t6- Then this screen appears, press OK<\/a>\n\t\t\t\t\t<\/h4>\n\n\t\t\t\t\t

\"\u0628\u0631\u0646\u0627\u0645\u062c<\/a><\/p>

\u00a0<\/p>

\"\u0628\u0631\u0646\u0627\u0645\u062c<\/p>

After this step, the items will have been defined in the Items screen, and you can undo or enter the opening balances of the items and press Save.<\/p>

\u00a0<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

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

Importing item data from an Excel file With Afaqy accounting software, you can import item data in a few seconds from Excel files, which relieves you of the trouble of entering items manually and saves you a lot of time and effort. 1- Who\u2026<\/p>","protected":false},"author":1,"featured_media":0,"parent":9970,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-10184","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/programsshop.com\/en\/wp-json\/wp\/v2\/pages\/10184","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/programsshop.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/programsshop.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/programsshop.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/programsshop.com\/en\/wp-json\/wp\/v2\/comments?post=10184"}],"version-history":[{"count":0,"href":"https:\/\/programsshop.com\/en\/wp-json\/wp\/v2\/pages\/10184\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/programsshop.com\/en\/wp-json\/wp\/v2\/pages\/9970"}],"wp:attachment":[{"href":"https:\/\/programsshop.com\/en\/wp-json\/wp\/v2\/media?parent=10184"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}