• When importing stock records into RetailEnterprise these records will be flagged to send to your store in the next product update.
• Duplicate barcodes, Packaged items, Weighted items, Sales bonuses for staff commissions, Sales prompts, and the ability to hide stock items in searches/reports cannot be imported into a RetailEnterprise Central database. 

To make sure that the 'Default Supplier' of your stock items is imported from RetailManager to RetailEnterprise Central, you need to export them from RetailManager before you export your stock records.

1. Open RetailManager.
2. Go to the File menu and choose Import/Export.
3. Click Continue. The Import & Export Wizard will appear.
4. Click Export Data then click Next.
5. If your shopfront name appears on step 2 of 4, click Next. If it does not appear, click Browse to select your shopfront. Once you have selected your shopfront click Next.
6. On step 3 of 4 select Suppliers from the drop down list, click Next then click Export. See our example below.
   
7. At the Save Table As window, specify the location where you want to save your exported supplier.txt file. The "RetailM" folder will be selected by default.
8. Click Save.
9. A message will appear advising you that the export was successful. Click Export again. 

1. While the Import & Export Wizard is still open from Task 1 above, click Export Data then click Next.
2. Click Browse to locate your shopfront.
3. Select your shopfront then click Next.
4. From the drop down menu select Stock. Note: You can use the supplier, custom 1, custom 2, department and category filters to select a particular stock. If you want to export all stock records, leave the filters set to <ALL>.
5. Select to export the cost and sell prices to be exclusive OR inclusive of tax.
6. Click Next then click Export. The Save Table As window will appear.
7. Select the location where you want to save your stock.txt file. The 'RetailM' folder will be selected by default.
8. Click Save.
9. A message will appear advising you that the export was successful. Click Finish.

The supplier.txt file exported in Task 1 above must be transferred to the computer on which RetailEnterprise Central is installed either by removable media, for example floppy disk, USB stick, CDR, DVD, etc., or via email.

1. Open RetailEnterprise Central.
2. Go to the File menu and choose Import & Export.
3. Select Import Data then click Next.
4. Click Browse and locate the supplier.txt file.exported in Task 1.
5. Click to highlight the supplier.txt file then click Open.
6. Click Next.
7. Click Browse. By default the "RMCentral" folder will appear. Click to highlight the RMCentral.mdb file then click Open. Note: The RMCentral.mdb file may appear as RMCentral.
8. Click Next.
9. At step 4 of 6:
1. Select Supplier as the type of data that you would like to import.
2. Select Header Info as the First Record Is option.
3. Select Tab as the Field Separator option.
4. Click Next.
10. At the Update or Add to table option, select Add then click Next.
11. Click Match all by name then click Import. A summary will appear advising you that the records have been added.

The stock.txt file exported above must be transferred to the computer on which RetailEnterprise Central is installed either by removable media (floppy disk, zip drive, CDR, DVD and so on) or via email.

Before importing, you may want to make some changes to the stock records in the stock.txt file. (that is remove duplicate bar codes and packaged items and so on). 

Stock records can be edited using a program such as Microsoft Excel. While MYOB Technical Support DO NOT provide advice on Microsoft Excel, a number of support notes have been created on this topic. 

To import the stock.txt file into RetailEnterprise Central, follow the below steps.

1. Open RetailEnterprise Central.
2. Go to the File menu and choose Import & Export.
3. Select Import Data then click Next.
4. Click Browse and locate the stock.txt file exported in Task 2 above.
5. Click to highlight the stock.txt file then click Open.
6. Click Next.
7. At step 3 of 5, select Tab as the Field Separator. Leave all other fields as they are.
8. Click Next.
9. At the Update or Add to table option, select Add.
10. Select Tax Inclusive or Tax Exclusive (as applicable) at the option Imported cost and sell prices are. Choose the same option you chose when exporting from RetailManager.
11. Click Next.
12. Select Match all by name then click Import. A summary will appear advising you that the records have been added.