Closed

ERP Integration plugin for SupeRep by WRNTY with MYOB

A new module is required to Import and Export data from/to MYOB to/from SupeRep.

ERP Integration with SupeRep – A Step by Step Guide

1. FTP Location Transfer of ERP files to the WRNTY cloud is executed via FTP file transfer. The customer will be provided with an FTP location, username and password to transfer files. For example: Output URL: ftp://[url removed, login to view] Input URL: ftp://[url removed, login to view] User name: Account_960162 Password: abcdef

2. ERP Output File Formats File formats required for loading Items, Accounts, and other types of entities are detailed in the attached Excel – ERP Integration Template.xlsx. Each entity has a list of fields, which are the column headings. Column headings must be identical to those assigned in the Field Name column. All entities are described in detail in the tabs of the Excel file. The ERP integrator or the on-site ERP admin is responsible for outputting the files in this required format as CSV files. File content must be reviewed to make sure only WANTED data is being loaded into SupeRep, and filtering must be adjusted accordingly.

a. File naming conventions File naming conventions are detailed for each entity at the top of each tab in the ERP Integration Template Excel file. Each entity is transferred in a file named by a generic convention, allowing SupeRep to pick up the file and know exactly what type of data it contains. Here is an example of one convention, which can be applied to understand them all: The Items-Inventory file should be named as follows:

[url removed, login to view] (also supported: [url removed, login to view])

A file time/date-stamped from August 24 2012 at time 14:32:45 from the distributor with ID number 153359 would be named:

[url removed, login to view] (also supported: [url removed, login to view])

b. Rate of file transfers WRNTY is constantly checking for files in the Prod_Input directory. The maximum recommended rate of item data file transfers from an ERP system to SupeRep is once every hour. The recommended rate of account data file transfers from an ERP system to SupeRep is once daily. Transfers at a higher rate can slow down your ERP.

3. Initial Creation of Brands and Filters: A sample ERP output file with Items is loaded via the SupeRep manager; this will initiate the Brands and Filters in SupeRep and ensure that data is being displayed in the SupeRep catalog according to the customer's requirements. This is done by the SupeRep admin in the usual way using the Excel mapping procedure.

4. FTP and integration

Once files are being transferred on a regular basis to WRNTY's FTP server, updates will automatically be loaded into SupeRep. Automatic generation of the files in the required WRNTY format, with the required naming convention as well as their transfer to the FTP location are the responsibility of the ERP admin or integrator on the customer's end.

5. Loading Product Image Files Images are loaded via the SupeRep manager interface on a browser. Images are uploaded in bulk. Image files must be named as their corresponding item code (exactly). Files selected will be automatically paired with their items in the catalog. (Images are not loaded from the ERP system. Images stored there are often of lower quality)

6. SupeRep Orders Integration

ERP integration of orders submitted on SupeRep App

Select "Export Order to ERP system" in the ERP -> ERP Setup option in the SupeRep Manager

Submitted SupeRep orders will automatically be placed in the "Prod_Output" FTP directory in XML format (default) or CSV format (one file per order).

The ERP admin or integrator on the customer's end is responsible for checking this FTP directory periodically, grabbing the order files, and then processing them within the given ERP system.

A sample order file in XML is attached.

Skills: ERP, Software Architecture, XML

See more: wrnty myob, superep plugin, superep integration, wanted it manager, user guide creation, template creation software, product list excel template, product creation software, myob online, excel to xml online, customer data excel template, catalog creation, by the hour, automatic data processing, online checking accounts, format xml online, checking accounts online, checking account online, setup product catalog with, product naming, online checking account, loading product, inventory creation, excel myob, erp

About the Employer:
( 9 reviews ) Westleigh, Australia

Project ID: #4646211

6 freelancers are bidding on average $4357 for this job

rsen75

i'm 14+ years experienced, ready to start

$4210 AUD in 45 days
(1 Review)
2.8
bmartynvw

Please read PM

$4850 AUD in 45 days
(1 Review)
2.4
expertzsol

Hi, i have gone through your requirements in detail and already have worked on a similar project and can deliver this as u have mentioned we have studied all the requirements and can deliver the same to u . we h More

$3684 AUD in 25 days
(0 Reviews)
0.0
BenjaminFree123

hi, i'm interested this project.

$5263 AUD in 30 days
(0 Reviews)
0.0
getveltrod12

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and t More

$4639 AUD in 75 days
(0 Reviews)
0.0
chirag89

Dear Sir, We have gone through your requirement and are ready to work on your project. We are having Software Developing Company and are expertise in developing ERP & CRM Systems. We are a team of dynamic and tal More

$3333 AUD in 40 days
(0 Reviews)
0.0
thindo

Thanks for the opportunity to bid on your project. I think I'm the best candidate for your project requirement because I have worked on similar projects. I'm ready to do with that also.

$3111 AUD in 30 days
(0 Reviews)
0.0
on2it

Hi there ! [url removed, login to view] are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional More

$6000 AUD in 40 days
(0 Reviews)
0.0