VinodPatel

Quote for importing vinodpatel (fiji) data. They will required two import programs

• - a category import program. There will be two files to import. One file to create the departments. This file will be imported as is, with no modificaions. Codes and Names will be imported. The second file (called sub-groups) will have the codes mofidied in the following way. If the code is 3 digts, a 01 will be prepended to the code. If its 4 digits, only a 1 will be prepended to the code

- a stock import program.

• These are the fields which will be imported:
• Item number
• Item description

• Category (made up of the subgroup field using the special transformation described above)
  • EAN (barcode)
    • Default supplier (supplier[0])
    • Purchasing unit (buy units)
    • No of items per purchasing unit (bufac)
    • Customs group (duty field - special mapping table is provided and this will need to be hardcoded into the import program)
    • Stock UoM (sale units)
    • Discount levels % 1-4 (pbreaks 1-4)
    • Cost
      • Price

Preliminary quote: 1 hr spent by bernie investigating category import - 2hrs stock import - 5 hrs time for quote - 2hrs testing - 2hrs total: 12 hrs (category and stock import)