Sales Module
Inventory Module
Printing Stocktake list sorted in the same order as on the screen.
POS improvements
1. Integrate with Loyalty schemes provider.
Stop or alert the staff member when they select the payment ‘On Account’ for a client who has reached the Credit limit.
Show the credit limit on the POS screen.
Add an access level feature to select by the business to sell ‘On Account’ by a cashier. Maybe only a “Manager” who could sell ‘On Account’.
Optionally disable access to the Dashboard for staff members.
DEAR Payments platform
Introduce the DEAR Payments platform to enable users pay bills directly from the systems. Functionality will be backed up by Stripe.
Complete for Australia clients.
2. Planned for USA clients.
WMS enhancements
1. Enable Warehouse Transfers for the WMS App
Make tote numbers in the WMS app optional More info requested
Make Pack and Ship steps optional
Make to order function
Manufacturing module enhancement
Manufacturing schedule
Work Centres & Capacities & Operations
Production BOM and Production Order
Clone Assemblies
RMA (return merchandise authorisation)
Return a product to receive a refund, replacement, or repair during the product’s warranty period.
Test environment provisioning
Snapshot of account/ temporary staging environment, sandbox to allow users to test functions, play around with system using their own data.
DEAR POS APP
Barcode Scanning capability into the DEAR iOS app
1.To support businesses that do not explicitly need a barcode scanner to be able to use the DEAR iOS app.
2.Implementing barcode reader software into the camera of the iOS app (iPad now, future for iPhone)
Integrations
ShipStation improvements:
Automatically add ShipStation shipping cost to Invoice for DEAR Sale Order
Move send voided status updates to ShipStation when sale is voided in DEAR
Automatically changing status from ship to authorised for shipments if it’s still in DRAFT in DEAR when ShipStation sends notification on shipping details with tracking number.
Listing of products in client_Custom menu set up:
Provide the customers with ability to set up their B2B portal to address the marketing goals
Set up custom navigation for B2B portal products listings
Implement sorting on B2B portal (client side).
DEAR B2B portal enhacement:
Include Company’s billing email in the B2B portal for the “Send email from”
2. Ability to for B2B customers to reply back to the email sent.
Woocommerce integration enhacement:
– Mapping of the Woocommerce meta data order fields with DEAR order fields.
Select multiple location rather than one or all locations for product availability in sales channels (e.g:shopify, B2B)
Integration with G Suite:
1.Google Drive linking (adding/linking files directly from Google Drive)
2. Google Sheets export (for reports and spreadsheets)
2. Pull the data into Google sheets
Single Sign on with Google
eCommerce Enhacement:
Bulk unlist/ remove products from ecommerce stores.
Inventory
Comprehensive PRODUCT DETAIL Page
Display product availability in terms of QTY, location and bin information in the product details page.
Include a thumbnail of the default product image attachment within the page itself.
Upload a product image.
Show margin in the quote/sales entry
– Option to see the margin of a product against the Fixed cost, not average when entering a sales order.
Add carton/item volume and pack quantity to product dimension tab and purchase order tab.
“Internal Notes” field for Products separate from “Description”.
Stock Transfer Enhacements:
1.Display stocks in transit in stock transfer.
2. View the stocks in transit in product availability report.
3. Implement a stock transfer report to focus on the differences between
ON ORDER – Transfer vs
ON ORDER – PO.
Production
Account for losses at the point they occur in order to capture
scrap/deviation points before actual yield in manufacturing.
Allow zero for Actual Yield for New Finished Goods production.
File Attachment tab for Finished Goods Assemblies allowing to add attachments to finish goods production assembly.
1. Create sequential serial numbers for Assembly Production.
2. Define the sequential serial number order.
3. Enter custom serial numbers (bulk/ individual) at product assembly.
Purchase
For each Document Template show/Hide slider option to hide unused document templates from the Print & Email button dropdown lists.
Add tooltip to show the content of purchase/sale note field at the Dashboard.
Reports
Commission percentage field on sale orders under Sales representative field and optionally be able to capture on Profit by Sales Representatives reports.
While Printing tax invoice prompt if sale is completed/Authorised in the Invoice Screen.
Support for attachments at customer level.
Sales
Refinements to Sales – Fulfilment View Filters.
While Printing tax invoice prompt if sale is completed/Authorised in the Invoice Screen.
Support for attachments at customer level.
Settings
Assign default template at customer and supplier level
Dashboard, quicklinks on all modules Sales, Purchase, Customers, Suppliers, Products
Global Search & Quick Links
1. A Global Search option to be able to quickly find customers, suppliers, sales orders, purchase orders and inventory items or any documents.
2. Search results displayed to be grouped by each category (for example customers, suppliers, invoices, products, etc.).
HubSpot integration
POS: Weight-Based products
Parse barcodes generated by scales to identify product, weight/quantity and price of the weighted product to seamlessly add such products to checkout without extra effort.
Integration with EDI and 3PL providers
B2B enhancements
Reporting
1. Report Scheduling – Improvements. Add more reports that can be scheduled.
2. Back-up feature –Scheduled report functionality will be enhanced to provide a zipped version of CSV files that currently available for download in DEAR
3. Add invoice ‘Payment Account’ as Reporting field to the reports where the payment amount is available
4. Add “Ship Date” (AKA “Shipment Date”) to Sale Reports. New fulfilment report will be available
5. ‘Quotes not Authorised’ Report. Add new option in Outstanding Quotes report and new filed status. New filter dropdown {All quotes, Drafts only, Authorised Only}
6. Add the Notes field to the Sale Order Details Report and Purchase Order reports
Audit Report and User Activity Log
1.View details of every action that was performed by user in application
2.View old and new values of critical system parameters and user who made the change
Shopify integration extension
Add support for Multiple Returns
User suggestions Phase 4
– Report scheduling should allow multiple conditions and multiple actions, so users can send different report layouts of the same report to different people
– Add option ‘All reports’ into Scheduled Reports
– Add reporting date range info when exporting reports as a file (PDF, Excel)
– Smart Period Defaults such as Last Year MTD (Month-to-date), Last YTD (Year-to-date) for reports
Improvement to Invoice Undo function
Allow editing purchase/sale Invoice details without undoing the entire purchase/sale. Also to make minor edits such as address changes, payment due dates, contact information will be available without undoing
POS – Stage 7 enhancement
1. Let user process Cash returns in POS even if original payment was made using non-cash payment method (like credit card).
2. Let user to print receipts for returns/exchanges
3. Implement offline mode for POS web version
4. In case of offline sale stays not synced for more than a minute, show indicator in POS app header (similar to how we show printer and other hardware issues).
5. Add “Petty Cash Reasons” tab to POS integration page
6. Configure Surcharge % for Custom Payment Methods
7. Add payment provider option to outlet definition
Zapier Integration
Update product information
Workflow and automation
External actions and automation rules. Document status change on external events
User suggestions Phase 5
– Unit of measure import/export
– Change report saving logic, add “Save Report As” option. Currently, you need to select a new report and name it before you are able to save the new report.
– Bulk pick list performance optimisation for large selections that include 100s of orders
– Include carrier on the pick list
Enhance Security Features
Optionally DEAR users will be able to:
– force user password changes on regular basis,
– disallow repeated password change,
– introduce two factors authentication using Google authenticator,
– user access log (login/logout datetime, change reference books data, product info, customer/supplier info)
POS – Stage 4 enhancement
– New User interface
– Integartion with Paymentsense, card payment solution for small businesses in the UK
POS – Stage 5 enhancement
1. Shipment from the store. Outlet will get order online and do shipment to the customer address.
POS – Stage 6 enhancement
2.POS Sales Prices per Customer. Price tiers assigned to customers when selected
3.Special access levels for price changes and discounts
4.Account on Hold option if client reached Credit Limit for On Account invoices
6.Change calculation module
User suggestions Phase 2
– Invoice Printed and Invoice Sent flags on the View All Sales Screen.
– DEAR Inventory, to allow return of items to different location it was purchased from
– Auto application of discounts, possibly a setting that will apply discount to the order upon Authorisation rather than having to click the discount button.
Smart reordering
– Reorder function analysis report
Account conversion function
To improve system performance conversion will reduce the amount of historical data system needs to select when making user requests. Conversion will create new account with opening balance, pending documents and make current account read-only. If required read-only account will be available for reporting and browsing only at fixed price
Add quick access icon (+) to the app top bar
Provide access to often used functions
Improve Reorder Backordered function
Add filter by Location. Currently it is calculating available stock in all locations combined.
Avalara tax software integration
Achieve compliance with sales tax requirements through automated, cloud-based solutions that are fast, accurate, and easy to use.
User suggestions Phase 1
– Increase list of events that can trigger notifications. Notification Options for: Minimum Stock Hit, Backordered PO Received, credit limit exceeded, sale made for exceeded credit account.
– Improve User management module, add import/export option, introduce User Roles.
– Special Access permissions to see Bill of Materials
– Add Address Finder/Autocomplete feature using Google Autocomplete Address Form
Partner portal enhancement
Add dashboard and make further changes to partner portal functionality
We will increase range of supported hardware, mostly printers and scanners
Customer and markup pricing
Individual product price per customer. Product page will have additional tab – Price where user can view/edit supplier and customer prices. Markup pricing will include:
1. Mark up from average cost,
2. Mark up from Fixed Price,
3. Mark up from Latest Price.
Inventory change logs and reporting
Log will be available to the end users and contain full breakdown of changes to available/on hand quantities
Product Family enhancement
View Additional Attribute values for variants with ability to specify them once attribute set is selected on Product Family.
‘No inventory tracking’ function
– Add ‘No tracking’ option at product level to suppress availability check when selling product
– Add ‘No tracking’ option at account level to suppress availability check when selling any products
QBO integration improvement
Several enhancements like optional auto-sync, connect/disconnect wizard to/from QBO, additional sync elements (categories, classes, custom fields) and help with sync errors resolution
DEAR to DEAR integration
Send or receive invoices directly to/from another DEAR organisation
Shipping zones
– implementing shipping zones down to postcode level
– import shipping rates from CSV file
User suggestions Phase 3
– Tasks and Notifications can’t sign up in trial, nor can a user trial the features when they have a paid account. Can we create some sort of trials for these modules which should increase take up? It would be good to have a code we can give out to users as a promotion that would allow them access for a defined period of time.
– Ability to delete customer/supplier contacts in bulk.
– Bulk actions for advanced sales orders.
Xero Integration
New option to consolidate sales invoices before sending to Xero to eliminate Xero’s 1000 orders per month restriction
Magento 2 Integration
Amazon integration improvement
Importing fees and charges
Order Routing
Use shipping address to route sales orders to specific warehouse
Shopify integration enhancement
Some extra features to utilise new Shopify API
Mobile app for warehouse managament
1. Stocktake/inventory count
2. Stock receiving
3. Put away
4. Stock write-off
5. Stock transfer
POS – Stage 3 enhancement
1. Product ordering. Outlet staff should be able to order products either
a) using reorder function or
b) by creating direct orders to supplier or
c) requesting transfer from main warehouse or other outlet
3. Serial numbers in POS
4. POS layout for smartphone
5. POS register customisable catalogue layout
6. Additional reporting
Pick and Pack mobile app
Android application for ScanSKU Android Barcode Scanner to streamline order fulfilment process and show all outstanding orders available for picking
Tasks, Reminders and Scheduled reports
Part of Notification module. When activated it will create a reminder on orders to approve, payments due etc. Also some DEAR reports can be generated on regular basis and emailed to distribution list. These reports perfect for those who are not logged into DEAR.
Shipping Rates Estimates and Shipping Labels
Shipping rates will be set manually (shipping zones) or provided via integration with following platforms: ShipStation, StarShipit, Shippit (including label printing)
Advanced Purchase Module
New purchase module to include
– Multiple invoices, credit notes and deliveries for single purchase order
– Standalone credit notes
– Service-only purchase
In-app messaging
Send messages to other DEAR users while they are logged in to DEAR web or mobile app
Xero integration improvement
Several enhancements like optional auto-sync, connect/disconnect wizard to/from Xero and help with sync errors resolution
B2B Portal – Stage 5 enhancement
2. Option for customer of B2B portal to email order/invoice from B2B portal to have a record other than just in DEAR
4. Send email notification to supplier when the invoice has been viewed/downloaded
5. Email notifications when customer opens and downloads invoice
7.Add shipping fee calculations based on total order weight or # of items. ( Will be done through a 3rd party shipping integration )
8.Additional Stock Availability Display
“In Stock” (green), ” Out of Stock” (red) and “Display Quantity” (green), if there is a stock outage, but also a quantity on order, the B2B Portal should display “Coming Soon” (amber)
Zapier integration
Zapier connects more web apps than anyone. Zapier integrates with apps such as Facebook Lead Ads, Slack, Quickbooks, Google Sheets, Google Docs & many more! Slack. Mailchimp. Google Sheets. Trello.
FBA integration improvement
Several changes to improve integration usability:
– Stock quantity auto-sync between FBA and DEAR location on daily/weekly/monthly basis
– User interface for Catalogue view to match general DEAR design concept
– Operation Log on FBA integration page to indicate some FBA related events, like catalogue updates.
API Version 2
Add to the List of available endpoints:
– All reference book endpoints
– Assembly
– Disassembly
– Inventory Write-Off
– Money tasks
– Journal tasks
– Customer/Supplier
B2B Portal – Stage 3 enhancement
B2B Portal – Stage 4 enhancement
2. Easy portal access for field Sales Representative that place orders on-site on behalf of customers (Impersonation of portals).
4. Add an icon that highlights NEW products.
5. Add an icon next to the “Invite to Portal” icon to tell if the customer has created a password/account.
6. Add another invitation status, “ACCEPTED”, to know the customer received the invite and accepted.
7. Add [CustomerEmail] to the B2B portal invitation email so when a customer receives the invitation and chooses a password they’ll also know which email they’ll need to use when signing in.
8. Access to logs confirming that an invitation was sent.
10. Product page display customisation:
– don’t show extra paramaters
– show in specifications tab
– show under product code on the main product section/next to the image.
11. A button to navigate back to the catalogue from the product info pages.
12. Change the backorder/split delivery descriptions. Make the heading “Delivery Options if one or more items are Out of Stock”:
– “Single Delivery; delay whole order until all items are in stock”
– “Multiple Deliveries; ship all available items now, ship currently unavailable items later”.
13. Show short description under product heading on the Product Info pages.
14. Ability to add customisable shopping cart icon.
15. Add ‘Back’ & ‘Checkout’ buttons to Product pages to streamline the customer experience. The text of these buttons will be customisable.
POS – Stage 2 enhancement
12. Incorporate Barcode scanners in POS.
15. Quick Keys
16. Pin codes for quick POS screen locking.
17. Implement live search for products and customers.
18. Custom payment methods.
Notification Centre
Users will be able to get an overview of all notifications stemming from various sources (B2B, e-commerce, in-app sales). This will help them become aware of critical real-time information.
Payment distribution
Improved supplier/customer payment distribution. Loading data from banks files
Mobile point of sale (POS)
POS works in the web browser, under Android or iOS. It supports offline mode, all sales created offline will be synced to your DEAR account once online mode is back.
Supports popular discounting models (buy one get one free, brand and category discounts along with simple discount per order or line item)
You include receipt note to record extra information about the sale. It will be printed (optionally) on receipt.
You can process Sale On Account, Layby and let your customers earn loyalty points. Full support for customer accounts.
Cashier can put sale on hold (park sales) to take payment from another register or recommence sale at any time later.
Refunds and Returns are available with options to put refund to store credit or return to the customer using original payment method. If loyalty program is enabled for the customer every time they make a purchase system calculates loyalty point that can be used in the future.
Accept credit/debit card payments through Square payment processor. Cash payment option is available as well and calculates change and applies rounding when required. Customer can opt to use different payment methods for a single sale that include cash, credit cards, gift certificates, laybys, on account sales and store credits.
Full receipt customisation is available. You can include info regarding current and forthcoming promotions, put your logo or logo of brans on sale, etc.
Register closure and cash management are supported
Support for Barcode Scanning. Add items to the sale by scanning. Also search products by brand, category, SKU
Every shop/outlet can me mapped to individual inventory location to have separate inventory control and counts for every outlet. Multiple registers available per outlet to report on sales activity. Every cashier has separate user account to control access permissions and track sales.
Credit note functionality
Multiple credit notes for single invoice, credit notes distributed across multiple invoices
Improved Expense Distribution
Expenses like freight and handling fees can be allocated to customer orders as manual journals using pro-rata method.
B2B Portal – Stage 2 enhancement
1. Download price lists with images as PDF file and excel file with product barcodes, SKUs, names
2. Add optional dimensions, weight, product attributes and quantity based discounts to the product details page when available
3. Add optional short description field to DEAR product page to be used along with product name on B2B product details page.
4. Add Guest user role which cannot shop, but can browse/print catalogue.
5. At checkout stage add two options to choose from :
– Single delivery, place on Backorder if out of stock
– Multiple deliveries if out of stock
6. Show fulfilment status on orders
B2B Portal
Our B2B portal allows your customers to visit your web shop (multiple shops supported) and make new order, see all orders made before. Copying items from previous order is available. Special pricing per customer and basic portal customisation are available. If you have Stripe or Paypal account your customers can pay orders online using these payment processor.
Multiple pick, pack and ship tasks for single sales invoice/order.
Multiple pick, pack and ship tasks for single sales invoice/order.
B2B Portal – Stage 1 enhancement
1. Implement payment options using Paypal and Stripe
2. Printing orders/invoices from the B2B portal. Single order/invoice template will be supported initially.
3. Optional ‘Required by date’ field for customers to enter. This field will be transferred to the ‘Required By’ field on DEAR Sales order page. Add checkbox ASAP next to it to indicate that it should be delivered as soon as possible.
4. Add new parameter on B2B integration page to control number of products on search/catalogue page. The number will be limited to 48 items per page to keep page response time acceptable.
5. Optional comment field on checkout page for every item in the cart
6. Content of Invitation, reset password, order notification emails should be customisable
7. Notes area on checkout page. Content will be saved to DEAR Sales order internal memo.
8. Use content of Carrier table to fill delivery methods on B2B integration page. At checkout step preselect delivery method as per customer’s carrier settings.
9. Add In Stock / Out of stock indicator to the items on all pages showing catalogue
Advanced Reporting
(Phase 1 complete). To simplify reconciliation between DEAR and your accounting software we are adding set of reports that will be comparable with the reports you can find in your accounting software.
Floship Integration
Floship is a leading provider of international fulfilment, recognised for fast and cost-effective worldwide shipping services.
Multiple DEAR organisations
Use single user login details to access multiple DEAR accounts
Vend – phase 2
Add import from Vend – purchase orders, stock transfer and stocktake
eBay Integration (Phase 2)
Add support for multiple eBay marketplaces. Add support for eBay variants. Import payments from eBay
Square
Square is one service that supports your entire business, from a register in your pocket to reports on your laptop.
Handshake
B2B Portal. Write bigger orders, See more customers, Process and ship your orders faster, Reduce order processing costs, Increase your order accuracy
Fulfilled by Amazon Integration
Magento Integration (Phase 2)
Add support for multiple Magento shops. Import payments from Magento
Paypal Checkout Integration
It works within your site—customers can pay instantly, without being redirected away to complete the transaction.
Import bills and invoices from Xero
When implemented this will open really unlimited integration opportunity for any Xero clients and add-on providers to take advantage of powerful DEAR Inventory features.
ShipStation Integration
POST/PUT methods to create/update sales, payments, tracking numbers and credit notes
Stripe Checkout Integration
Checkout is an embeddable payment form for desktop, tablet, and mobile devices. It works within your site—customers can pay instantly, without being redirected away to complete the transaction.
Amazon Marketplace Integration
CSV file load for purchase and sales
Let users load historical sales and purchases from accounting systems or sales channels.
Etsy Integration
Capsule CRM
API Interface – Phase 2
POST/PUT methods to create/update sales, payments, tracking numbers and credit notes
Neto integration
WooCommerce integration
Vend integration
Big Commerce integration
Disassembly module. Auto-disassembly.
New module will let users disassembly items when multiple output items will be inventoried from one input item. This feature also will be used to do automatic conversion between different units of measure (e.g. box to items, tonnes to kilos etc.).
Bulk product upload for Shopify and Magento
While currently available publishing functions for sale channels work fine there is a need to have bulk publishing option clients who maintain 1000s of items.
Commission based drop shipping
Currently drop shipping model implemented in DEAR Inventory assumes retailers make their profit on the difference between the wholesale and retail price. But some retailers earn an agreed percentage of the sales in commission, paid by the wholesaler to the retailer. So changes will be done to job costing module to allow commission based invoicing to wholesaler/manufacture.
Repair order module
For users who do after-sale service and who sell items with serial numbers (e.g. electronics), the Module will keep records on all repairs and service calls associated with particular serial number.
Individual tax rules per invoice line
Adding tax rules per invoice line will make DEAR invoice fully compatible with invoices produced by accounting software like Xero or QBO. Currently DEAR users can’t create mix of taxable and not taxable items in one invoice.
Drop Ship functionality
During a Sales Order if an item is marked as Drop Ship, out of stock or it is best to Drop Ship you should be able to mark specific items for Drop Ship. This would then direct you to create a Purchase Order directly associated with that Sale Order. This Purchase Order would then be a Drop Ship and not be received into inventory. After that it is just a matter of Invoicing SO and PO normally.
Email Templates
You will be able to pre-set emails you are sending to customers and suppliers.
Mobile version of stocktake page
You will be able to do your stocktake on a mobile device not just onto printed stock sheets.
Fulfilment integration with Shopify
Shopify will send an automated email to the customer once its order is full filed. If the orders are pushed from Shopify to DEAR, once an order is shipped i.e. fulfilled, the information of shipment should be pulled back to Shopify too.
Kitted or Packaged Products/SKUs that are not preassembled into finished good but simply a list of other (already finished goods) SKUs
New checkbox is added in the bill of materials ‘Auto-Assembly/Kit’ indicating that products can be automatically assembled when sale order is authorised. If the product is available in stock the system will assemble only deficiency in quantity required to complete the sale order.
Product Traceability and Track Expiration Dates
Ability to enter specific lot numbers of products, usage of each traceable product, information on when date sensitive products are due to expire, facilitate with product recall by identifying the immediate previous sources and immediate subsequent recipients of products
Backorders enhancement
Create purchase orders only for backordered items filtered by customers and/or product tags
Finished goods enhancement
Finished goods now can include not only direct materials but also direct labour and applied manufacturing overhead
Stock take/ Stock adjustment enhancement
Add function to data entry stock in addition to loading from CSV file
Product Family enhancement
Create and maintain, buy and sell similar products applying bulk select/update operations. Auto-generate SKUs.
Shopify integration
Volume Based Discounts
A volume based discount is an adjustment to the price of a item based on the quantity in the quote line or order line item. Simple method will be used.
Serial/Batch Numbers Tracking
Track serial or batch numbers on the receiving stock side and the selling side of business.
Application Dashboard
Summary of outstanding tasks and quick shortcuts to the most used actions.
Recurring Invoices
Enter details for a sales invoice you send and mark it as Recurring Task. DEAR will automatically create and save invoices with Draft status. You’ll need to complete the process by authorising them.
User-defined fields for customers and suppliers
Let you keep additional information about your customers and suppliers specific to your business.