Introduction

Before you start installing the Store Manager application, you must first install the SQL Server from Microsoft, as the Store Manager App will not work without the SQL Server installed. You can directly download SQL Server to your device through the following link: SQL Server 2022 Express

Install Store Manager

Step 1

Download store manager through this link Store manager download.

Step 2

Run the installation file that you downloaded in the previous step and follow the wizard as in the following image:

Please accept the agreement and click Next.

Step 3
Select destination location, and click Next.

Step 4
Select create a desktop shortcut, and click Next.

Step 5
Setup is now ready to being install Store Manager on your computer. Click Install.

Getting Started

Launch Store Manager on your Windows computer, A window will appear to start setting up the program for the first time, as shown in the following image:

Step 1
Server name Select the server instance to connect to from the drop-down list, If you do not find the correct server to connect to the database engine, you can click on browse for more button to get all the engines connected to your network.

Step 2
Authentication type offers authentication modes when connecting to a Database Engine, in most cases you will use Windows Authentication to connect the Engine, if you use Server Authentication, you should go to step 3, otherwise go to step 4

Step 3
User name and Password The user name and password to connect with. This setting is read-only when you select Windows Authentication, otherwise you should fill user name and password that you created when you insatlled windows server.

Step 4
Enable integration with Al ameen sytem You should not enable this option if you do not have Al-Ameen program installed on your computer.

Step 5
Test Connection To make sure that the connection settings to the data engine are correct, you can press this button, and if the connection to the database engine is successful, the following message will appear

Step 6
Save It will save connection settings, if setting saved successfully, the following message will apear

Step 7
Click Next button to get the next window in the wizard, which will appear as the following image

In this window, the settings for connecting to your online store will be set.

Step 8
Your Store Link please provide a valid link to your store.

Step 9
Consumer key and Secret key are authentication credentials used in the context of WooCommerce, an e-commerce platform for WordPress. They provide a secure way for third-party applications to interact with your WooCommerce store's data and perform actions on your behalf.

Step 10
Test connection Click on this button to verify that the connection settings that you provided in the previous step are correct, and if the connection to your store is successful, a message will appear to you as in the following image:

Step 11
Congratulations, you have successfully completed the connection to your store, you can now click on the Finish button and start using the application.

General Statistics

When you run the application for the first time and after you have finished adjusting the connection settings to your store, the application window will appear without containing any statistics or information, as shown in the following image:

This window will be the main window in the application, which will always appear every time you run the application, and in order for this window to become useful and contain information, you must take the following steps:

Step 1
Click Synch All Orders button at the top of the window, as shown in the previous image, A message will appear:

Step 2
Click Yes to start feching orders form your online store.

After the application finishes fetching orders from your online store, the window will change to contain statistics and information that will help you get valuable insights about your customers, products, sales breakdowns by city, payment methods, and even the devices used for purchase.
With a dedicated annual profit report, you can follow your financial growth efficiently, as the window will look similar to the following image:

Main Buttons

At the top of the application window, you will find the following buttons:

• Processing Orders:When you click on this button, you will get all orders that are currently being processed, where you can take the necessary action for these orders like printing or changing their status
• Synch All Orders: Retrieving all orders from your online store with status: completed, canceled and deleted.
• Customers List: You will get a detailed list of all the customers of your store, where you can print this list, export it to Excel, or search for a specific customer.
• Products List: Retrieving list of products from your online store.
• Add Report: To add a new invoice printing report to the application.

Statics window sections

You can find also in main Statics window the following:

Monthly sales chart: This visual representation illustrates the sales distribution throughout the months of the present year when juxtaposed with the previous year. This allows for a direct comparison of sales performance for a specific month in the current year with its counterpart from the prior year,as the following image:

Additionally, you have the option to access a comprehensive report easily printable or exportable to PDF or Excel formats,by clicking More Details button on the chart. This report will provide a detailed overview of monthly sales spanning all years since the beginning of opening of your online store. This valuable resource will offer you a clear perspective on the progression of your online store's sales over time. the following image will dispaly how report will be:

Sales by city Chart: Presenting a graphical representation that visually displays the geographical breakdown of sales by city. This enables you to discern the specific areas where your sales exhibit the highest concentration, as shown in the following image:

Top products: A chart showing you the best-selling products, as shown in the following image:

To acquire a comprehensive report, suitable for both physical printing and digital analysis, detailing the tally of products sold, simply click on the "More Detail" button. This report can be further exported in either Excel or PDF format. the report will appear as in the following image:

Top Devices: Presenting a graphical depiction that illustrates the device categories employed for placing orders. This chart serves as a valuable tool for informed decision-making during the execution of advertising campaigns on social media platforms. By incorporating diverse perspectives to arrive at well-informed conclusions, this chart mirrors the visual format showcased in the provided image:

Orders Summary: This section provides general information about:

• The value and number of completed orders.
• The value and number of canceled orders
• The value and number of failed.

Idle Valued Return Customers: Providing a compiled list featuring valued returning customers who have not made a purchase in over 45 days. The format of this list aligns with the visual presentation exemplified in the provided image:

returning customers: Here is a list of your important customers. They are sorted based on how many times they have ordered from you and how much they have spent in total. as the following image:

Orders by Payment Method: This list displays the different payment methods offered in your online store. For each payment method, you can see the number of orders that have been placed using that method.

To obtain a detailed report on payment methods, you can click on the Sales by Payment Methods button, where the following report will appear:

Processing Orders

Step 1
Launch Store Manager on your Windows computer.
Step 2
From the main screen of the application, click the "Processing Orders" button, or you can just press the F9 key. This will gather all the orders that you need to handle. A window will then show up, similar to the image below:

Main Buttons

At the top of the previous window, you will find a group of buttons, as shown in the following image:

• Select All: This lets you decide whether to pick all orders in the order list or not.
• Bulk Action: A list of actions you can perform on the selected orders. This list includes:
  1. Move to Trash: This action removes the chosen orders and places them in the trash.
  2. Change status to on-hold: This action changes the status of the selected orders to on-hold.
  3. Change status to completed: This action marks the selected orders as completed.
  4. Change status to canceled: You can use this action to cancel the selected orders.
  
• Apply: This button let you apply selected action on selected orders.
• View: Clicking this button generates an invoice report for the selected order from the list. You can print the invoice or export it in PDF or Excel format as the following Image:.
  
  
  
  Note
  Before clicking this button, make sure to select an order from the list. To select an order, simply click the left mouse button on the desired order anywhere in the list. The order will then highlight in light blue. Once selected, you can press the View button to generate the invoice report.
• Refresh: Clicking this button will refresh the orders list by retrieving the latest orders from your online store.
• Print All: This button allows you to print all the chosen orders simultaneously.
• Report Designer: "Edit Invoice Design" Clicking this button opens a powerful tool, that allow you to modify the invoice design or even start a new design from scratch. The report design tool will be similar to the following image:
  
  To learn more about how this tool works, you can click Report Designer .
• Show/Hide Column: A window will appear in which you can hide and show columns in the orders list, as in the following image:
  

Processing Orders window sections

You can find also in main Statics window the following:

Summary of Orders: This part gives you the count and amount of current proccessing orders, Similar to the following image:

Sales By City A graph showing detailed current sales(Processing Orders) values by city, This helps you know where we're selling the most, and give you an initial visualization of which cities you should ship orders to,and it will also become clear to you which cities are where sales are most concentrated. The graph will similar to the following image:

Top Products: A list showing you the best-selling products for current processing orders, as shown in the following image:

Top Devices: This will give you an idea of the type of devices on which orders were placed, and this will help you a lot when you create your advertising campaigns during the targeting stage, as you can customize the devices on which your advertising campaigns will appear. You will see a list of devices similar to the following image:

Payment Methods: This list displays the different payment methods offered in your online store. For each payment method, you can see the number of orders that have been placed using that method. the list will be similar to the following image:

Add New Invoice Report

Step 1
Launch Store Manager on your Windows computer.
Step 2
From the main screen of the application, click the "Add Report" button A window will then show up, as the following image:

1. Navigation buttons: enable you to browse stored reportsز
2. Template name: Shows the name of the current report.
3. File path: shows the file path for the current report.
4. ... Browse button:This button enables you to choose one of the default reports as we will mention later, or even a new report that you have created previously, to be the basis for a new report, where all the components and elements of the selected report are copied to the new report, and after that you can modify it from the Report Designer tool tool.
5. Set As Default Report: Enabling this option sets the current report as the default choice for printing invoices within the Preocessing Orders window
   Note
   You can't delete the default reports, which is:"A4 Design" and "Thermal paper size"
6. Add New Report: USe this button if you wannt to add new report.
7. Save Use this button to apply and save changes.
8. Delete: To delete current report.
   Note
   You can't delete the default reports, which is:"A4 Design" and "Thermal paper size"
9. Close: To close Add Report window.

Within this application, you have the flexibility to customize the appearance of your invoices as you wish , and through this window you can add, delete, or browse the stored reports. In order to use the Report Designer tool in the processing orders window, it's better to create new report through this window first , and not use the default reports that come With Store Manager.

The installation program will create two files "A4 Design.fr3" and "Thermal paper size.fr3" Within a folder called Store-Manager, as the following image shows:

Create New Report

To create new report folllow these steps:

Step 1
Click Add New Report button.
Step 2
Enter the name of the new report in the Template Name.
Step 3
Click on the three dots button to choose the default report, you can choose A4 Design.fr3 file for invoice with size A4 , or Thermal paper size.fr3 for thermal printers with width 80mm.
Step 4
Enable "Set As Default Report", if you want this report to be the default report.
Step 5
Click Save button to save the new report, and this will generate new file with name same to the "Template Name" in "Store-Manager" folder which is located "My Documnet".

Invoice Report Designer

This is a handy tool made by Fast Report Company. It helps you create designs for your invoice in order to appear elegantly and reflect your business activity. The designer is equipped with the necessary tools to design the report and display it or even print it. When you open the report designer, it will appear similar to the following image:

Window sections

This window contains the following sections:

1. Report design workspace: All elements are dragged and dropped onto it, ultimately forming the final report
2. window title: Contains the name of the report that is currently being modified.
   
   Note
   You can add many reports to the invoice design by clicking on the Add Report button
   
3. toolbars: It contains many controls to adjust the report elements within the report body.
4. rulers: a ruler can be dragged onto a report page to create a blue guideline on the page (objects snap to nearby guidelines).
5. “Object inspector” pane: Through it, you can specify the properties of any element present in the body of the report
6. Object Toolbar: It contains the basic objects that make up the report. Any object can be dragged and dropped into the body of the report. These objects can be like a text object or an image object.
7. Data tree : It contains two important sections to show order information, which are Order head and prod Details, You can drag any of the elements to the report page.

Bands in report

Bands are used for logically placing the objects it contains at a location on the output page. When placing an object in a band, such as “Page Header,” we tell the report engine that the given object must be displayed at the top of each page of a finished report. Similarly, the “Page Footer” band is displayed at the bottom of each page together with all the objects it contains.

When you open the report designer, you will find the report page consisting of the following bands:

• Report Tilte: this band is displayed at the top of the first page.
  

  To change any text in report title:

  Step 1
  double click on the text which you want to change.

  Step 2
  A window will appear allowing you to change the text as in the following image:

  

  Step 3
  Change the text, and then click OK button

• PageHeader: this band is displayed at the very top of each page.

  

  In addition to the text object, this band contains a data object that represents the data in the order, such as the order number, order value, order date, and other various values of the order.

  To represent any of the order values and display them in this band, drag the object that represents this value from data tree band located on the left side of this band and drop it into this band.

• GroupHeader: must be placed above the data-band, which in our case is MastetData

  

  It contains text objects that represent a description of the order elements, such as the line number, item description, quantity, total price, and the tax value can also be added.

• MasterData: this band contains a data object that represents the order items values in the order, such as item_name, sku, qty, price, vat_ratio, tax_total , and line_total.

  

  drag the object that you want to represent it's value from data tree band located on the left side of this band and drop it into this band

• GroupFooter: The position of this band is immediately after the data band, which in our case is MasterData

  

  It contains data objects that represent the total of the order, the shipping value, and the tax value. This band can contain text objects or data objects.

• ReportSummary: This band is displayed at the very end of a report.

  

• PageFoooter: this band is displayed at the bottom of each page together with all the objects it contains. it contain informatin like page number.

  

Your Customer Information Tool

The program equips you with a robust tool for gaining comprehensive insights into your customer base. This tool empowers you to:

1. Understand the demographic distribution of your customers.
2. Determine the number of clients in each state.
3. View a list of all your online store customers, which can be printed or exported in Excel or PDF format.
4. View a list of clients categorized by their respective states, also printable or exportable in Excel or PDF format.
5. Conduct searches for customers based on their phone numbers or partial names, and display their respective data.
6. Retrieve information on the total order values for each customer.
7. Identify the date of the customer's most recent purchase.
8. Discover the device type used by customers.
9. Access additional details such as the customer's country, phone number, state, address, and email.

Ultimately, this tool enhances your understanding of your customer base, making it easier to target specific audiences in your advertising campaigns. This knowledge empowers you to fine-tune your business strategies, providing better service to your customers and ultimately increasing your sales.

To show a list of customers for a specific city:
Step1
choose the name of the city from the drop-down menu “preview customer per city”
Step2
Press the “Apply” button.
Step3
If you want to print this list or export it in Excel or PDF format, you can click on the Print button and this will generate a report for you as in the following image:

Export to Excel: To Export report in Excel format, click on save icon in the toolbar, toolbar will be like the following image: