Manage Products

The manage products section is where you can add, search, edit, delete, import and export products. 

Adding New Products

In the manage products section there are two ways in which you can add products. Firstly you can click add product which is ideal if you only want to add a few products. Alternatively you can import products via excel which is a quick and easy way to import an unlimited number of products. 

Searching Products

Providing you have purchased some credit and have added some products you can search by Product Name, Category, Manufacturer, Product Type, Published and SKU. If you have added a product but have not purchased a Top Up your product will have saved but will not visible and you will not be able to edit it until you add some credit.

Edit Products

To edit a product simply click the edit link on the product you wish to update. Editing products individually is exactly the same as adding a new product for detailed description see www.the-reseller-netwrok.com/resource-centre/add-new-product/. 

Delete Products

To delete products select the tick box for an individual product or select the box at the top left to select all products on the current page. Once you have selected the product(s) you wish to delete click the delete button. Please note once deleted this can’t be undone so only delete if you are sure otherwise you may prefer to unpublish the product instead.

Import / Export 

The Import / Export button is where you can find everything you need to be able to import and export products. 

You can export a PDF catalogue of all your products which includes basic info such as Name, Price, SKU and product images. 

You can also export all or selected products to Excel file which very useful if you want to make bulk updates to your products. 

Import from excel enables you to bulk import products with images via excel file. 

Download category list enables you to download an excel file of all the available product categories that are relevant to your profile according to your selected industry(s) in Edit Profile.

Download Manufacturer list enables you to download an excel file of all the available product categories that are relevant to your profile according to your selected industry(s) in Edit Profile.

Bulk Import Products

The quickest and easiest way to upload a lot of products including product images is by using the Import from Excel feature in Manage Products. Most websites and marketplaces have the ability to export products to excel or csv file, if you are able to do this you can very quickly import and unlimited number of products. If you are unable to export your products to csv or excel you could still save a lot of time uploading products by copying and pasting your product details into and excel file which can then be imported.

Before creating your excel file to import it is recommended that you configure product settings including tax, shipping and payment options. For further details on configuring your product settings visit: www.the-reseller-netwrok.com/resource-centre/configuration/

Once you have configured your settings we recommend that you add one or two products manually making sure that you include all the necessary details. You can then click the Import / Export button and select export all found to Excel. This will give you an import template with real product details that you can follow when adding the rest of your products.

To complete your template you will also require the correct product category and if applicable the manufacturer ID’s for each product. Click the Import / Export button and select download category list for the full list of all available product categories for your selected industry(s). Click the Import / Export button and select Download Manufacturer list for the full list of available manufactures and their corresponding ID that you require for the import file.

Each of the columns in the Export / Import is labelled with a self-explanatory headings as follows:

Name – the product name (Mandatory)
ShortDescription – product short description with no images or HTML and should include top 3 to 5 keywords
FullDescription – detailed product description which can include HTML formatting and images
MetaKeywords – product keywords such as the product name, product type and manufacturer
MetaDescription – short description of the product that will be displayed on search engines and should not be more than 160 characters 
Industry – the industry for the product (Mandatory)
Category – the main product category (Mandatory)
SubCategoryName – the product subcategory (Mandatory)
SKU – the stock keeping unit or product code
ManufacturerPartNumber – the manufacturer part number
Gtin – Global trade identification number which includes EAN, UPC, JAN & ISBN.
Currency –From our supported currencies enter the 3 letter currency code e.g. GBP, EUR, USD 
Price – the trade / wholesale unit price 
RecommendedResalePrice – the recommended resale price or RRP
OldPrice – the original price if the product is now discounted
ProductCost - your total cost of producing or purchasing the product, for your reference and reports only
SpecialPrice – discounted price which has a start and end date
OrderMinimumQuantity – minimum order quantity
orderMaximumQuantity  - maximum order quantity
Weight – product weight in kg(s) which is required to configure shipping cost by weight
Length - product length in centimetre(s)
Width – product width in centimetre(s)
Height – product height in centimetre(s)
ManufacturerIds – manufacturer ID, a list is available via the Import / Export button in manage products
StockQuantity – stock quantity 
MinStockQuantity minimum stock quantity, you can set automatic notifications and actions when stock reaches this level 
ProductTypeId – Enter 5 for Simple Product and 10 for Grouped Product
ParentGroupedProductId – the product ID for the parent product
VisibleIndividually - Enter TRUE or FALSE. Generally it is TRUE unless it is a part of a group and you do not want it visible individually
ProductTemplateId – Enter 1 for Simple Product Template and 2 for Grouped Product Template
SeName – Search engine friendly name, if left blank we will automatically update this for you only enter a value if you are experienced in SEO
Published – Enter TRUE to publish the product or FALSE if do not want it visible
RequireOtherProducts – Enter TRUE if other product(s) are required to purchase
RequiredProductIds – Enter the ID for 
AutomaticallyAddRequiredProducts - Enter TRUE to automatically add required products
IsDownload – Enter TRUE if the product can be downloaded for example software or media products
DownloadId – Enter the download ID
UnlimitedDownloads – Enter TRUE or FALSE
MaxNumberOfDownloads – Enter a number to set maximum number of downloads
DownloadActivationTypeId – Either when the order is paid or manually allow enable users to download.
HasSampleDownload – Enter TRUE or FALSE
SampleDownloadId – Enter the sample download ID
HasUserAgreement - Enter TRUE or FALSE
UserAgreementText  - Enter TRUE or FALSE
IsRental - Enter TRUE or FALSE
RentalPriceLength -
RentalPricePeriodId - 
IsShipEnabled - Enter TRUE or FALSE
IsFreeShipping - Enter TRUE or FALSE
ShipSeparately - Enter TRUE or FALSE
AdditionalShippingCharge – Enter additional shipping charge in £GBP
DeliveryDateId – Enter the delivery date
IsTaxExempt – Enter TRUE or FALSE 
TaxCategoryId - Enter the tax category ID
IsTelecommunicationsOrBroadcastingOrElectronicServices – Enter TRUE or FALSE
ManageInventoryMethodId - Enter the inventory tacking method to determine whether you want to track stock and if so by which method.
LowStockActivityId – Enter the low stock activity ID to configure what happens when the product reaches you low stock limit.
NotifyAdminForQuantityBelow – Enter a number of items to receive an email when you stock reaches this level.
BackorderModeId – Enter back order ID to configure whether you wish to allow orders to be placed even when stock level reaches 0.
AllowBackInStockSubscriptions – Enter TRUE or FALSE to notify reseller when the product is back in stock.
DisplayStockAvailability  – Enter TRUE or FALSE
DisplayStockQuantity – Enter TRUE or FALSE
AllowedQuantities - Enter the allowed order quantities such as 10, 20, 30, 40 to receive orders only for these amounts.
AllowAddingOnlyExistingAttributeCombinations – Enter TRUE or FALSE
DisableBuyButton – Enter TRUE or FALSE
DisableWishlistButton – Enter TRUE or FALSE
AvailableForPreOrder – Enter TRUE or FALSE
PreOrderAvailabilityStartDateTimeUtc - Enter the date and time to start allowing pre-orders.
SendInterstForPrice – Enter TRUE or FALSE, if TRUE no price will be shown and resellers must send interest to request pricing. 
SpecialPriceStartDateTimeUtc – Enter the date and start time for the special price to begin
SpecialPriceEndDateTimeUtc  - Enter the date and end time for the special price to expire
BasepriceEnabled – Enter TRUE or FALSE for example to show price per litre or per kg
BasepriceAmount – Enter the base price for example per litre or per kg
BasepriceUnitId – Enter the base price unit ID
BasepriceBaseAmount - enter the base price for example £10 per kg
BasepriceBaseUnitId -enter the base price unit ID
ImageURL1
 – Enter the image URL
ImageURL2 - Enter the image URL
ImageURL3 - Enter the image URL
ImageURL4 - Enter the image URL
ImageURL5 - Enter the image URL
Attribute1 – Rename this heading to the required attribute 
Attribute2 – Rename this heading to the required attribute 
Attribute3 – Rename this heading to the required attribute 
Attribute4 – Rename this heading to the required attribute 
Attribute5 – Rename this heading to the required attribute 
Attribute6 – Rename this heading to the required attribute 
Attribute7 – Rename this heading to the required attribute 
Attribute8 – Rename this heading to the required attribute 
Attribute9 – Rename this heading to the required attribute 
Attribute10 – Rename this heading to the required attribute 
Specification1 – Rename this heading to the required specification 
Specification2  – Rename this heading to the required specification 
Specification3  – Rename this heading to the required specification 
Specification4 – Rename this heading to the required specification
Specification5 – Rename this heading to the required specification
Specification6 – Rename this heading to the required specification
Specification7 – Rename this heading to the required specification
Specification8 – Rename this heading to the required specification
Specification9 – Rename this heading to the required specification
Specification10 – Rename this heading to the required specification

We have added over 200,000 specification attribute options which are very product specific and assigned to their relevant product subcategories. When manually adding products you will find some specifications are displayed in bold, these also act as filters in Browse Products. If you import products with any of these specification values they will automatically be filters too. Any values that you import are not filters will show on the product page only.

Most of these fields are not mandatory however Name, Industry, MainCategory, SubCategory and ImageURL1 are mandatory fields. 

In order for your products to be published you also need make sure every cell for VisibleIndividually and Published says TRUE.  

If you do not want to show pricing or want to show only RRP make sure that every cell for  SendInteresForPrice says TRUE otherwise your products will show as £0.00.

SKU is used as the unique identifier rather product name so to avoid duplicates make sure you include the SKU for each product. If two or more products have the same SKU only one will be imported. When you want to bulk update your products simply export your all found products to excel, make any changes and import the file again. For each existing SKU the updated product information will be updated. Any new SKU’s create new product listings.

ImageURLs you can import up to 5 images using the URL (link) to for each image. If you are exporting products from another website should have this in your exported file. If you are creating an import file manually view the image you want, right click your mouse and select “Copy Image URL” “Copy Image Location” or “Copy Image Address” depending on which browse you use. Then paste this link into the image URL column on your import template. Your image URL must contain the full path and be in a valid format as below:

https://www.the-reseller-network.com/images/profileimages/22176.png - VALID 

This image url contains the website domain, full path and ends with supported image extension such as .png .jpg .jpeg

/images/profileimages/22176.png – INVALID

The above URL is incomplete because the website domain is missing which means our servers won’t know where to look for it.

https://www.the-reseller-network.com/images/profileimages/22176.png?1244335/ - INVALID

The above image URL is complete however there should be no text after the image extension, in this case .png.  If all your image URLS are like this you can solve this quickly and easily. Select the image URL column(s), then Find (ctrl+f) to find .png* and Replace with .png this will remove everything after .png for all your images.

Please also note that it is not possible to import images using image preview URLs which sites such as Dropbox provide.