How to Generate the Proper Report Format Using Clover POS Software
Installation for CLOVER
Log into your Store Profile.
Scroll down to the blue Store Information & Configuration Section and keep scrolling as needed until you see two or three yellow horizontal lines on the right side.
Between the yellow lines is a list of three files. Each one needs to be downloaded and saved in your Document folder (aka My Documents on some PC's).
Download each one using a right-mouse-click and choose "Save Link As" or "Save Target As". Navigate to your Documents folder and click on SAVE or CHOOSE. Do not run any of them.
Ignore or bypass all security warnings and when finished you should have three new files in your Documents folder. MALLUPLD.EXE (or MALLUPLD on some PC's) has a three cherry icon.
Last step and this is done for your convenience. Locate the new SALES_UPLOAD.BAT (or SALES_UPLOAD on some PC's) file in your Documents folder. Do a right-mouse-click and chose "Send to ..." Desktop (shortcut). This places a convenient shortcut on your Desktop to make it easy to find the helper app that will actually do the transfer of your Sales file to Mall-Central.com (see below).
When you save your Report File (see below) you will need to save it in your Documents folder.
There are two reports Mall-Central.com can read from Clover.
One kind of file comes from Store ID "CB". The second comes from Store ID "TSB".
Use Clover to create an Items Report file that looks like this:
Items Report "Jan 6, 2021 12:00 AM - Jan 8, 2021 11:59 PM" "Requested on: Jan 8, 2021 12:19 PM" Filters: Item Type = Revenue Items Categories: All "The report reflects all revenue items in paid, partially paid, partially refunded and refunded status. Does not include open orders." . . .Prepare the report for not more than one day at a time such as the current day. If you missed uploading yesterday then prepare a report for yesterday and upload that. You may upload many times in one day but only one day at a time.
After creating the report and saving it as sales.txt, minimize all screens and launch the helper app on your Desktop (called UPLOAD_SALES.BAT). This is actually a shortcut.
Launch the shortcut by a double-left-click. A black DOS window will open and the hard to read white text will give you an ETA when the upload will finish. Daily files such as from Clover will be small so the upload may happen fast.
Next, your Sales Report will appear. Enter your Store Password as needed, click on SUBMIT and verify that today's sales are displayed. As you close or minimize windows you will notice that the black DOS window is still present. You can dismiss this by hitting any key or closing the window.
If a sale from a previous day needs to be corrected then correct it in Clover. Depending how you corrected the sale you do have the option to re-upload a previous day.
Dealer ID's will have spaces removed and are limited to 20 characters. While Clover may support longer names with spaces, the Mall-Central Dealer ID will have spaces removed and be truncated to 20 characters.
Mall-Central.com parser is CLOVER (not CSV).
Store ID "CB".
Most POS programs can export sales data over a specified time period such as from the 1st of the previous month to the current date. However, while you can do the same in Clover, what Clover does is it dates all transactions with the same date of the export.
Therefore, the only way to differentiate a sale from any day vs any other day is to export only a days worth of sales each day. If you miss a day then you will want to upload all the missing dates together and you will just have to tolerate the Mall-Central.com report showing all those sales under the exported date.
Upload once per day unless the first upload did not work.
Clover will export your sales in a CSV format. A couple lines of data in a typical export file will look like this:
2.12434E+11,,Z35DBPM47VK2J,,Glass Straw Cleaning Brushes,,1,,USD,0.99,,0,0.99,Vendor W15 - Marge Quinine 2.17704E+11,,BW3FKASME83RT,,Greeting Card,,1,,USD,3.5,,0,3.5,Vendor 1110 - Jane Smith 2.99084E+11,,XATBTVZS0YZHY,,H3 Bourbon Salt,,1,,USD,6,,0,6,Vendor H3 - John DoeThe first 4 fields are ignored. The next field is Description followed by a blank field followed by Quantity and then other fields such as prices. The names of these fields in Clover is unknown to us.
Note that the last field (name of field in Clover is unknown) is where the Dealer ID located (ie Vendor H3 - John Doe). Notice that the word "Vendor" followed by a space then the Dealer ID (no spaces) followed by a space. The hyphen and Dealers name is optional. Because there needs to be a space after the Dealer ID it is probably a good idea to at least include the hyphen and Dealers name.
The name of this report in Clover is unknown.
The Export File must be named "sales.txt" to work with our Helper Files.
The parser used by Mall-Central.com is CSV (not CLOVER)
Back to Store Page instructions