A key message relating to importing of historical data: historical data brought in as a result of an import should be regarded as reference only. It's a great help if you need to know how much of something sold last year to plan your buying this year. In the event you need data that is perfectly accurate eg; for an IRS auditor, or to pay last months sales tax then you should run the report from the original system. It's simple to keep the backups around for a long time as required. It is against RITE policy to allow customers to use previous data imported from a 3rd party system for any data reporting where Generally Accepted Accounting Principles (GAAP) would be applicable. A: Yes, but.. The system links the sales history to the products and customers records in a particular way so:
Q: Will the import merge customer records? A: It may. We do not use account numbers as the key differentiator for the customer import, we instead check first name, last name, and the address 1 field. If those are all the same we assume it's the same customer. The result is that if you have 2 customer accounts in RMS with the same information but separate accounts the two will be merged when importing into CR. This is particularly useful for multi-store customers moving over to CR. Q: If I have a single store and I want to migrate one POS over today and import my sales history and then a month from now migrate the remaining POS stations over, can I? A: Yes, however, the same rules mentioned above regarding products and customers apply in this scenario as well. Q: Will my sales journal images move over with the import? A: No. While we can import the sales transaction history we cannot migrate images of the receipts printed in RMS. Q: Will my tax data move over? A: Yes, however, all historical data imported should be used for reference only. If you are being audited by the IRS the imported data may not have the level of accuracy required to provide that level of detail. Please continue to keep a backup of your RMS database or printed reports for this purpose. Q: Why are my imported sold costs for sales history not an exact match to RMS? A: We apply FIFO costing to sales history as well based on past purchase orders to maintain consistency with costing in Cloud Retailer. All values applied to sales are derived from imported purchase orders. Q: Will sale prices and other price changes import into cloud retailer on our final import? A: Yes. We do a final import before go live to gather any item changes made since the initial import. This includes sales prices, sale start and end dates, regular prices changes, cost, and other attributes. Changing a primary item lookup code however will result in a new item created and this should be avoided. Q: Will my discount schemes move over? A: Yes! Most Discount schemes should automatically import into Cloud Retailer. However, we will need to create names for these imported discounts as RMS doesn't always have a name for a discount. These imported discounts will import from RMS as "RMS Imported Discounts" and should be easily identifiable as such. Q: Can I migrate multiple stores worth of data over if I'm not using RMS HQ? A: No. Due to database inconsistencies between systems, there's no easy way to cleanly merge the data. We've tried in the past and the results were not very good. We had a well-organized client with 3 large liquor stores with what they had products set up in their system consistently. What we found were things like:
This is a near-literal example and these folks were well organized! The best part was when they tried to figure out which product UPC 12345 or 5555, they couldn't find those UPCs on any product as they were probably old. As a result, when we were trying to attach sales data to a product record the system had no clue how to manage it. For customers that absolutely need an import process that varies from our SOP we recommend that they manage it through our import utilities themselves OR if they commission us to do something custom, the costs are significant - because the work is complex, tedious, and hard to get right (risky). Typically starting at $5,000. Q: Will any of my Product Codes (UPCs) Change? A: Yes. Certain special characters will be replaced with an Underscore ( _ ) during the import process. Characters that will be replaced include the following: & # $ ( ) . * ^ , ; and blank spaces. There may also be cases where because of these substitutions there are multiple products with a very similar code. In this case, we will add an underscore and a number to the end (ie 5555_1 and 5555_2, etc). As a result of these changes, some of your products may not scan. In these cases, you can still search the product by description and complete the sale at the POS. Q: Does Any of my Supplier / Reorder Information Change? A: Yes. However, in RMS, Blank Reorder Numbers were allowed and in Cloud Retailer, they are not. We will replace any blank reorder numbers with the Item's Product ID. This ID will be prefixed by a series of letters so you can identify these for later updates. Additionally, CR does not allow 2 products from the same supplier to share a Reorder Number. In the event that you currently have duplicate ReorderNumbers, we will append the ID of the entry to the Reorder number; eg; AB1234_1122 and AB1234_5526 instead of 2 copies of AB1234. Q: Can You Import my Cashier's? A: Yes, but not their Passwords. Please check with your Project Manager regarding the password reset procedures that are needed after the import is complete. Q: What about Deleted Employees? A: All records associated with a Deleted Employee will be mapped to a new Cashier named 'Unknown Cashier' and will be imported under that user. (Sales Transactions, Purchase Orders, etc) Q: What will happen to items or other things I've deleted from RMS? A: Products which have been deleted from RMS but which are present on a sales transaction will be mapped to an item named 'Deleted Item' this will allow historical sales data for retired items to import, but not the item itself. Inactive items from RMS will be imported to CR as inactive items. Cashiers and Customers who have been removed will also be remapped to an Unknown Cashier record to ensure accurate reports. Q: What about Aliases? A: As long as your Alias exists in RMS and isn't also the primary UPC of another item, it should import no problem. Q: What about Loyalty Points, Vouchers, Gift Cards, etc.. A: RITE Fireworks Loyalty Points will be imported if they exist. RMS Vouchers, RITE Gift and some 3rd Party gift card or loyalty services can also be imported. For anything related to a 3rd Party, please mention to your CSL during the product kick-off meeting so we can be sure to prepare any required import files for you. Q: Do I have to close all my Purchase Orders before import? A: We will import Open Purchase Orders from RMS to CloudRetailer. The imported Purchase Orders will carry over the Date Created from RMS to Cloud Retailer. To ensure a fully accurate inventory, you should close all Purchase Orders that are received before the Import. Any unfulfilled Purchase Orders should remain open, however, you will need to update the EntryTime of the imported Purchase Order when you close the Purchase Order. If you have questions, please speak with your Import Tech. Q: Will the import move ALL my data over? A: It will move a lot of it but not all, for example, there are product fields in RMS that don't exist in CR and vice versa. Those data fields are not mapped. Once we complete the import the onus is on the retailer to check and verify that the data import meets their expectations. If something did not get imported in a way the user finds suitable it is likely that it will not be able to be imported after the fact without incurring additional costs or possibly not at all. Some other key bullet points (some of which repeat but bear repeating):
NOTE: This advanced import functionality is ONLY available for Microsoft RMS migrations and is likely not available for other types of imports. |
Tech Articles > Other >