Import a CSV, grab images from a URL, resize, and then create a product in Open Cart

General information for the website: We sell electronics online
Kind of development: Customization of existing website
Description of requirements/features: Please see my Moqup here: https://tinyurl.com/h5pgerf (Press the right arrow key on your keyboard to see the second screen).

Basically there are two options for the user: Upload a CSV file for DJI products. Or type in information for other brands.

When the user selects a suitable file and press the "Upload, Import and Create Products" button the system uploads and then parses the CSV file. The CSV will be in the following format:

Item Name,
Manufacturing Code,
EAN Code,
Dealer Price (USD),
RRP include VAT (GBP),
DJI.com URL

This system will do the following processes:

1) For each line in the CSV which has a URL entered; Does the Manufacturing Code, and EAN, already exists in Open Cart? If not:

1) Create SKU by getting the most recent SKU from Open Cart and adding 1 to it. EG If the last SKU was 4301058 the new one will be 4301059.
2) Calculate wholesale price by using the following formula:
'RRP include VAT' - 10% (This percentage value should be stored in the database so that it can be changed in future)
3) Grab all of the product photos from the URL provided, resize them to be suitable for Open Cart using http://image.intervention.io/ or similar and name them appropriately using the product name - EG djironinmx.jpg, djironinmx2.jpg, djironinmx3.jpg (Add 'dji' to the beginning of all photos processed this way)
4) Grab the product description from the URL

Then create a new product in Open Cart with the following fields populated:

SKU (Insert this into Model and SKU fields in Open Cart)
DJI Part Number (Insert into MPN in Open Cart)
EAN (Insert into EAN in Open Cart)
Product Name (Insert into Product Name in Open Cart)
Manufacturer (Always set this to DJI)
Price (insert into Price in Open Cart without VAT (divide by 1.2))
Wholesale price (this should be entered into the Open Cart database so that it appears in the discount tab for the "Wholesale" group)
The product description (Put the product description from the URL here (which the user can edit in Open Cart later)).
Insert the product photos into Open Cart. The first one should be the main photo in Open Cart, and the other photos should be additional photos (they should be resized and named properly as above).
Product Status (Should be "Awaiting Approval" - this is a status that exists in our Open Cart and products with this status are invisible on the front end).

Then go to the next line and continue. This may therefore create several new products at once. A message should show when the process is finished listing how many new products were created and/ or listing any errors encountered. EG CSV in wrong format, Open Cart Database inaccessible, etc.

If the user is making a product for another brand he will press the "Create New Product" button and be taken to the second screen in my Moqup. He then enters the information and when the "Create Product in Open Cart" button is pressed the system creates a new product in Open Cart with the following fields populated:

SKU (Model AND SKU in Open Cart)
Product Name (Product Name in Open Cart)
Price (entered into OC without VAT - divide by 1.2)
Wholesale price (Entered into the database so that it appears in the discount tab for the group "wholesale")

The product photos should be grabbed from the URLs provided, resized using http://image.intervention.io/ or similar, and named properly using the product name for reference - eg fpv250camera.jpg from the product name "FPV 250 Camera") and uploaded to Open Cart with the main image as the main image, and the other (upto) six as additional images.

The product created should have the status "Awaiting Approval" (this is a status on our existing Open Cart system, another mod makes products with this status invisible on the front end).

Our Open Cart version is 2.0.3.1.
Extra notes: