Opencart Marketplace Product Mass Upload Version2

Opencart Marketplace Product Mass Upload Version2

Opencart Marketplace Product Mass Upload add-on is super useful for bulk upload of products. Using this Marketplace add-on, the sellers can upload their products in bulk using CSV, XML, and XLS files also the admin can bulk upload products for himself and into the seller’s store. The admin and sellers will also be able to update their products in bulk and can export their product in bulk or by specific product selection.

This module is an add-on of Marketplace Module. To use this module you must have first installed the Opencart marketplace module first.

Note: This extension will work with Webkul’s Opencart Marketplace version 2.2.0.0 and above.

Features – Opencart Marketplace Product Mass Upload

  • The Admin/Seller can Import Bulk product using the XML, XLS, and CSV file types.
  • The Admin/Seller can Update Bulk product using the XML, XLS, and CSV file types.
  • The Admin/Seller can Upload images in Bulk using the CSV and Zip file types.
  • The admin can set the limit for the number of images that can be uploaded via CSV file.
  • The Admin/Sellers can get the ID data of selected options like – Product, Catalog, Manufacturer, Filter, Download, and Stock Status.
  • The Admin can Upload products for the sellers.
  • Export Product in Bulk/Specific products via email.
  • Multiple products in a single CSV, XML, and XLS file.
  • The seller can add multiple options, special, discounts, custom fields for a single product.
  • Set Multi Language Attributes, product description.
  • If an SEO Url is repeated then it will auto generate with a 4 digit random character.
  • The products can be added in multi-language.
  • The seller can add images to the server using zip file and create its own folders.
  • Fully dynamic and easy to use.

Opencart Marketplace Mobile App

This is a technology based era where everything is simplified even the online shopping. We all know about shopping apps and its advantages-how it reduces and makes our shopping experience hassle proof. So it is very important for all the Store owner to have a shopping app for providing a more convenient way to shop from their online store and now Webkul’s has launched its new app Opencart Marketplace Mobile App. Opencart Marketplace Mobile App converts your marketplace store for Opencart into a mobile app. Your customers can easily purchase products on the go. They don’t need to have a laptop or desktop, they can easily explore your store through their smartphones. It will not only benefit the store owner and customer it will benefit the sellers too. Sellers can see their dashboard, order history through the mobile app. So what are you waiting for, you must now have an Opencart Marketplace Mobile App to be a step ahead.

  • Seller list.
  • Seller Collection.
  • Seller Profile.
  • Seller Dashboard.
  • Seller Order History.
  • The customer can contact the seller.
  • Market Place Sell Page
  • User can review seller.
  • Seller Location is mentioned on the map.

Installation

Installation of Opencart Marketplace Product Mass Upload for Opencart is very simple. After extracting the zip file, choose your Opencart Version Folder and in that, you will find folders admin, catalog, and ocmod folders. Now copy the admin and catalog folders into the root directory of your Opencart website.
installation of opencart module

Also, you need to copy the system folder in the Opencart root that you will find along with the Opencart Version folders.

installation of opencart module

If you are using a custom theme like Journal then we provide Journal theme patch (directory) in the module zip. While installing the module, navigate through Theme Patch->Journal2 folder and you will get “Catalog” folder. Just upload the “Catalog” folder into your Opencart root directory for the proper functioning of the module with the Journal Theme.

installation of opencart module

Once you have uploaded the file, login to admin panel and from catalog section go to Extensions> Extension installer and upload the XML file. The XML file can be found in ocmod folder under module directory. Under the ocmod folder, you will find wk_mpmassupload.ocmod.xml file.

uploading zip file

After Uploading The File Go To The Extensions > Modification and Click On “Refresh“.

refresh

Now, navigate to Sytem->Users -> Users Group and edit the administrator. Here, under Access Permission and Modify permission click select all for both options and click the Save button as shown below in the snapshot.
installation of opencart product mass upload

After That Under Extension > Modules, install the Marketplace Mass Upload module like this way.

installation of opencart product mass upload

After clicking the edit button in the above snapshot, another page to configure the extension will appear as shown below.
Backend-Module-Configuration-1

Here, the admin will –

  • Enable or Disable the extension.
  • Enable Keyword that will –
  1. If the product is being updated then the SEO will contain SEO+Product Id.
  2. If a new product is being added then SEO will contain the provided SEO and random four characters.
  3. If the keyword is disabled – the product will be skipped and error will be shown for that product.
  • Set the Image CSV Limit – The admin can set the limit for the number of images that can be uploaded via CSV.
  • Set the Seller Allowed File Types – File types that the sellers will be allowed to upload

Now, navigate through Extensions->Modules->Marketplace and click the edit button. Now, go to the Catalog Configuration tab and under that go to the “Account” tab. Then for the “Allowed Account Menu” click the select all option and then click the Save button to save the configuration.

installation of opencart product mass uploadNow, go to the Product tab. Here, only the allowed product fields and the product tabs that are selected by the admin from the backend will be available for the sellers to use while uploading and exporting their products.
Admin-Configuration

Module Translation

As this Marketplace module supports multiple languages so this section will describe how to make the module work in different languages. Please check this link for language translation

Opencart Marketplace Product Mass Upload  – Importing Data(Admin’s End)

Using this module, you can allow importing the data from a file in XML, XLS, and CSV format.

General

Step 1: To import the products navigate to Mass Upload >General menu option in the admin panel as shown below in the snapshot.

Massupload_Add-Option

Here under the “General” tabthe admin will be able to –

  • Select the File Type as XML, XLS, and CSV.(For the below example, we have used  XML file type for importing the products).
  • Select the Option to upload – New Products Only or Update Old Products.
  • Click the Upload button to upload the XML file.
  • Lastly, click the “Save” button to import the products.

After clicking the “Save” button, the products will get imported and you will see a confirmation message as per the snapshot below.
Admin-XML-File

XLS Example:

Step 1: To import the products navigate to Mass Upload > General menu tab under the seller account section as shown below in the snapshot.

Admin-XLS-Upload

Step 1:
For importing products via the XLS file – 

  • Just select the File type as “XLS“.
  • Then select to Add New Products(You can select to update the old products as well).
  • Upload the XLS file having the Product Information.
  • Set the Sub-Category Separator.
  • Select the Column Separator(Separator for Multiple Values in the Option).
  • Click on the “Category”(Select the default category if you have not added in the file).
  • Now, click on the “Next” option to go to the next step.

Step 2:
Now, you will have to match the product and file values under the “General Tab“.
Admin-XLS-General

Now, you(The admin) need to match the product and file values for the rest of the tabs

  • Description
    Admin-XLS-Description
  • Attributes
    Admin-XLS-Attributes
  • Options
    Admin-XLS-Option
  • Reward Points
    Admin-XLS-Special
  • Special
    Admin-XLS-Special
  • Discount
    Admin-XLS-Discount
  • Product Images
    Admin-XLS-ProductImages
  • Custom Fields
    Admin-XLS-CustomFields
  • Seller
    Admin-XLS-Seller

Now, after mapping all the fields for all the tabs click the “Save” button to save the products, after which you can see the success message as shown below in the snapshot.
Admin-XLS-Success

CSV Example:
Admin-CSV-Initial

Step 1:
For importing products via the CSV file –

  • Just select the File type as “CSV“.
  • Then select to Add New Products.
  • Upload the CSV file having the Product Information.
  • Select the Column Separator(Separator for Multiple Values in the Option.).
  • Click on the “Category” to assign category if no category has been assigned to the product.
  • Now, click on the “Next” option to go to the next step.

Step 2:
Now, you will have to match the product and file values under the “General Tab” as shown below in the snapshot.

Admin-XLS-General

Now, you(The admin) need to match the product and file values for the rest of the tabs

    • Description
      Admin-XLS-Description
    • Attributes
      Admin-XLS-Attributes
    • Options
      Admin-XLS-Option
    • Reward Points
      Admin-XLS-Special
    • Special
      Admin-XLS-Special
    • Discount
      Admin-XLS-Discount
    • Product Images
      Admin-XLS-ProductImages
    • Custom Fields
      Admin-XLS-CustomFields
    • Seller
      Admin-XLS-Seller

Now, after mapping all the fields for all the tabs click the “Save” button to save the products, after which you can see the success message as shown below in the snapshot.
Admin-CSV-Success

Image

Seller-Image-Upload

Under the Image tab, the admin will be able to –

  • Select the Seller for Uploading the Images.
  • Select the Image Upload File Type as CSV or ZIP file(Upload CSV to use Image from a different server or If you want to use an image from your own server then select ZIP file)
  • Upload the Image file(The file should be a CSV and ZIP file).
  • Select the Separator for the file.
  • Enter your folder name(You can also create a separate folder for the seller or select a folder for the seller).

The admin can even check the existing images for the seller.

After filling all the required details, click the Continue button on the top right-hand side after which you will be directed to the step 2 as shown below in the snapshot.

Image-Seller-Step2

Here, the admin will map the values with the in file values and click the Save button to save the images for the selected seller.

Get Id

Under this tab, the admin will be able to get the Ids for –

  • Products
  • Catalog
  • Manufacturer
  • Filter
  • Download
  • Stock Status

After selecting an option, now click on the search box to display the IDs for the selected option.

For example – We have selected the option as “Product” and then we clicked on the search box. Now, you can see the Products displayed with their IDs. Similarly, the admin can get the IDs for the rest of the options(Catalog, Manufacturer, Filter, Download, and Stock Status).

Get-Id-Admin

Export

Now, the admin will be able to easily export the products for the marketplace sellers. The admin needs to select the seller, the mail on which the exported file will be sent(Admin, seller, both), the Backup File Type(CSV, XML, XLS), the Download Type(Format of the export file – CSV, XML, XLS), and the Download Type as Bulk(all products of the seller are exported) or Selection(only the selected products are exported) as shown below in the snapshot.

Export-Products

After making all the selections above, the admin will click on the Export button to export the products for the seller. After the export, the seller can find the exported file in their email as shown below in the snapshot.

CSV:
Export-Products-CSV

XML:

E-mail-Seller

Similarly, the admin can select the XLS format for exporting the products in bulk or by selecting specific products to export.

XLS:

XLS-Exported-Backup

Information

Admin can find more information about the module under the Information tab as shown below in the snapshot.

Module-Information

Opencart Marketplace Product Mass Upload  – Importing Data(Seller’s End)

Seller’s End

Using this module, the sellers can allow importing the data from a file in XML, XLS, and CSV format under their own account panel.

General

XML Example:

Step 1: To import the products navigate to Add Products > General menu tab under the seller account section as shown below in the snapshot.

Seller-Section-Massupload-General

Here under the “General” tabthe Seller will be able to –

  • Select the File Type as XML
  • Select the Option to upload – New Products Only(to upload the new products) or Update Old Products(Update the new Products).
  • Click the Upload button to upload the file with the product data.

After setting up all the parameters, click the “Save” button at the top right-hand side. Now, after clicking the “Save Button” the file will get uploaded and the products will be imported under the “Product List” section of the seller’s account.
XML-Sucess

XLS Example:

Seller-General-XLS

Step 1:
For importing products via the XLS file – 

  • Just select the File type as “XLS“.
  • Then select to Add New Products.
  • Upload the XLS file having the Product Information.
  • Select the Column Separator(Separator for Multiple Values in the Option.).
  • Click on the “Category” to assign category if no category has been assigned to the product.
  • Now, click on the “Next” option to go to the next step.

Step 2:
Now, you will have to match the product and file values under the “General Tab“.
Seller-General-Step-XLSNow, you need to match the product and file values for the rest of the tabs

  • Description
    Seller-Description-XLS
  • Attributes
    Seller-Attribute-XLS
  • Options
    Seller-Options-XLS
  • Special
    Seller-Special
  • Discount
    Seller-Discount
  • Reward
    Seller-Reward.
  • Product Images
    Seller-Product-Images
  • Custom Fields
    Custom-Fields

Now, after mapping all the fields for all the tabs click the “Save” button to save the products, after which you can see the success message as shown below in the snapshot.
XLS-Success

CSV Example:

Seller-CSV-Product-Upload

Step 1:
For importing products via the CSV file – 

  • Just select the File type as “CSV“.
  • Then select to Add New Upload New product.
  • Upload the CSV file having the Product Information.
  • Select the Column Separator(Separator for Multiple Values in the Option.).
  • Click on the “Category” to assign category if no category has been assigned to the product.
  • Now, click on the “Next” option to go to the next step.

Step 2:
Now, you will have to match the product and in file column values under the “General Tab” as shown below in the snapshot.
/Seller-CSV-General
Now, you need to match the product and file values for the rest of the tabs as shown below –

  • Description
    Seller-CSV-Description
  • Attributes
    Seller-CSV-Attributes
  • Options
    Seller-CSV-Options
  • Special
    Seller-CSV-Special
  • Discount
    Seller-CSV-Discount
  • Reward 
    Seller-CSV-Reward
  • Product Images
    Seller-CSV-Product-Images
  • Custom Fields
    Seller-CSV-Custom-Fields

Now, after mapping all the fields for all the tabs click the “Save” button to save the products, after which you can see the success message as shown below in the snapshot.
Seller-CSV-Success-Message

Image

Under this tab, the sellers can upload images using the two file types – CSV and ZIP. Upload CSV to use Image from a different server or If you want to use an image from your own server then select ZIP file.
Seller-Image-Tab-Section

Here, the sellers will select the:

  • Image Upload file type(CSV or ZIP).
  • File to upload.
  • Separator for the file(Use a comma in case you are using the CSV file type).
  • Folder for your previously added Folder or Add a New one.

Format of the CSV file

The seller will select the CSV file if the seller wants to use images from a different server. The seller will enter the link of all the images(after opening the images in the browser and then copying their address), the folder path(where the images will be saved), and the image name(enter name for each of the images else if you leave it blank then the image name will be used up randomly from the link of the image).
Zip-Image

Now, upload this CSV file under the Image tab and click the next button to proceed further.
CSV-image-upload
Now, the seller will map the values with the in file values and click the Save button to save the images.

map-values

** Note: The admin can set the limit for the images within the CSV file from the admin backend settings of the extension.

Format of the ZIP file –

If the seller wants to use the images from his own server then he can select the ZIP file for uploading the images. Just put all the images that you need in a zip file and then upload this file to save the images to your own server.

Save-Images

Now, clicking the Save button will save the images.

Get ID

Get-Id-SellerUnder this tab, the seller will be able to get the Ids for –

  • Products
  • Catalog
  • Manufacturer
  • Filter
  • Download
  • Stock Status

After selecting an option, now click on the search box to display the IDs for the selected option.

For example – We have selected the option as “Manufacturer” and then we clicked on the search box. Now, you can see the Manufacturers get displayed with their IDs. Similarly, the seller can get the IDs for the rest of the options (Products, Catalog, Filter, Download, and Stock Status).

Export

Now, the seller will be able to easily export their products.
Seller-Export

The seller just needs to select the –

  • Mail(the email on which the exported file will be sent – Admin, Seller or Both).
  • Backup File Type as – CSV, XML, or XLS.
  • Download Type as – Bulk(all of the products will be exported) or Selection(Selected products will be exported).

CSV-Bulk-Example

Similarly, the seller will be able to select the backup file type as – XML, and XLS and the selected file types will be sent via email.

Information

Under this section, the seller will be able to see the information regarding the extension as shown below in the snapshot.
Information-Tab-Seller

Opencart Marketplace Mass Upload – Updating Old Data(Admin’s End)

The module allows the admin to update the old data from a file in XML, XLS, and CSV format. For updating the old products navigate through  Mass Upload->General.

General

XML File Example

Under the General section, the admin will –

  • Select the File type as XML
  • Select Update Old Products to update the old products
  • Upload the XML file with the Updated data
  • Lastly, click the Save button to update the products.

Note: To add the products, the admin will just set the seller Id=0 or just leave it empty in the in-file Seller_ID column value.
XML-Add-Product-Admin

After the products have uploaded you can see the success message.
XML-Success

XLS File Example
XLS-Admin-1
Step 1:

Under the General section, the admin will –

  • Select the File type as XLS
  • Select Update Old Products to update the old products
  • Upload the XLS file with the Updated data
  • Select the Sub-category Separator
  • Select the Column Separator
  • Select the Category if not added in the XLS file.
  • Lastly, click the next button on the top-right hand side to move to the next step.

Step 2: After clicking next you will see the “Update” tab. Here, you need to map the map the product ID with the in file column values as shown below in the snapshot.

XLS-Update

Now, the admin need to match the product and file values for the rest of the tabs

  • General
    XLS-General
  • Description
    XLS-Description-1
  • Attributes
    XLS-Attributes
  • Options
    Heading name goes here
  • Reward Points
    Heading name goes here
  • Special
    Heading name goes here
  • Discount
    Heading name goes here
  • Product Images
    Heading name goes here
  • Custom Fields
    Heading name goes here
  • Seller
    Heading name goes here

Lastly, click on the Save button to save the update and you can see the success message as well.
Heading name goes here

CSV File Example

CSV-Admin-Upload

Step 1:
For importing products via the CSV file – 

  • Just select the File type as “CSV“.
  • Then select to Add New Upload New product.
  • Upload the CSV file having the Product Information.
  • Select the Separator for the file.
  • Set the Subcategory Separator.
  • Select the Column Separator(Separator for Multiple Values in the Option.).
  • Click on the “Category” to assign category if no category has been assigned to the product.
  • Now, click on the “Next” option to go to the next step.

Step 2: After clicking next you will see the “Update” tab. Here, you need to map the map the product ID with the in file column values as shown below in the snapshot.

XLS-Update

Now, the admin need to match the product and file values for the rest of the tabs

  • General
    XLS-General
  • Description
    XLS-Description-1
  • Attributes
    XLS-Attributes
  • Options
    Heading name goes here
  • Reward Points
    Heading name goes here
  • Special
    Heading name goes here
  • Discount
    Heading name goes here
  • Product Images
    Heading name goes here
  • Custom Fields
    Heading name goes here
  • Seller
    Heading name goes here

Lastly, click on the Save button to save the update and you can see the success message as well.
Heading name goes here

Opencart Marketplace Mass Upload – Updating Old Data(Seller’s End)

The module allows you to update the old data from a file in XML, XLS, and CSV format. For updating the old products navigate through  Add Products->General.

General

XML File Example

Under the General section, the seller will –

  • Select the File type as XML
  • Select Update Old Products to update the old products
  • Upload the XML file with the Updated data
  • Lastly, click the Save button to update the products.

Note: Correct Product ID is required in the XML file for updating.

Update-Product-Using-XML

After clicking the save button, you will see the success message as shown in the below snapshot ajja.
Update-Product-Using-XML-Success-Message

XLS File Example

Step 1:

Under the General section, the seller will –

  • Select the File type as XLS
  • Select Update Old Products to update the old products
  • Upload the XLS file with the Updated data
  • Select the Sub-category Separator
  • Select the Column Separator
  • Select the Category if not added in the XLS file.
  • Lastly, click the next button on the top-right hand side to move to the next step.

Update-Product-XLS

Step 2:

After clicking next, you will have to map the product Id and other values with the file values.

Note: Product Id is a mandatory field for updating the products.

Update-Seller-Update-Tab

Now, click the next button and match the product and in file column values under the “General Tab” and the other tabs as shown below in the snapshots.

  • General

General-XLS

  • Description
    XLS-Description
  • Attributes 
    Attributes-XLS
  • Options 
    XLS-Options
  • Special 
    XLS-Special
  • Discount
    XLS-Discount
  • Reward
    XLS-Rewards
  • Product Images 
    XLS-Product-Images
  • Custom Fields
    XLS-Custom-Fields

Now, after mapping all the fields for all the tabs click the “Save” button to save the products, after which you can see the success message as shown below in the snapshot.
XLS-Success-1

CSV File Example

CSV-General

Step 1:
For importing products via the CSV file – 

  • Just select the File type as “CSV“.
  • Then select to Add New Upload New product.
  • Upload the CSV file having the Product Information.
  • Select the Separator for the file.
  • Set the Subcategory Separator.
  • Select the Column Separator(Separator for Multiple Values in the Option.).
  • Click on the “Category” to assign category if no category has been assigned to the product.
  • Now, click on the “Next” option to go to the next step.

Step 2:

After clicking next, you will have to map the product Id and other values with the file values.

Note: Product Id is a mandatory field for updating the products.
Update-Seller-Update-Tab

Now, click the next button and match the product and in file column values under the “General Tab” and the other tabs as shown below in the snapshots.

  • General

General-XLS

  • Description
    XLS-Description
  • Attributes 
    Attributes-XLS
  • Options 
    XLS-Options
  • Special 
    XLS-Special
  • Discount
    XLS-Discount
  • Reward
    XLS-Rewards
  • Product Images 
    XLS-Product-Images
  • Custom Fields
    XLS-Custom-Fields

Now, after mapping all the fields for all the tabs click the “Save” button to save the products, after which you can see the success message as shown below in the snapshot.
XLS-Success-1

That’s all for the Opencart Marketplace Product Mass Upload extension. Still, have issues or want to give your suggestions to make this module better just raise a ticket at webkul.uvdesk.com