Store Manager is almost one of the most important applications for managing orders of WooCommerce stores easily and quickly, because it contains tools that facilitate printing the order and changing its status, in addition to the important reports and statistics generated by the application, which help the store owner to make the right decision . Thank you for trusting and choosing us. Here are the details of Store Manager.
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
Download store manager through this link Store manager download.
Step 2Run 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.
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
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.
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:
At the top of the application window, you will find the following buttons:
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:
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:
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:
At the top of the previous window, you will find a group of buttons, as shown in the following image:
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:
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:
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:
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".
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:
This window contains the following sections:
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:
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.
The program equips you with a robust tool for gaining comprehensive insights into your customer base. This tool empowers you to:
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: