Wholesale Import

Create import task

You start by creating an import task. You can find this setting in the CCV Shop maintenance tool via ''Starting point > My products > Wholesale Import''. On this page you see an overview of all the wholesalers and you can see which import tasks have already finished. You can see this by the date that is next to the import task (figure 1). 

Tabs

When you have chosen the wholesaler you want to import, you will see a number of tabs. The step-by-step plan below explains what these tabs mean and how you can successfully complete the import.

Creating a new import task is as follows:

1. Click on 'add'. 
2. Click on the "Product options" tab. (below there will be more information about this).
3. Set the product options.
4. Click on the "Category options" tab.
5. Set the category options (below there will be more information about this).
6. Click on the "Layout" tab.
7. Determine the layout settings here (below there will be more information about this).
8. Click on the "Available categories" tab.
9. Indicate here which categories you do or do not want to import again (below there will be more information about this)
10. Klik op het tabblad “Producten filter”.
11. Indicate which item numbers you do not want to import into your web store again (separated by a comma).
12. Click on the "Price lines" tab.
13. Determine the price rules for the products here.
14. When you have set all these tabs, click Apply.
15. The import task is now displayed in the "Current import tasks" list. After about 10 minutes your task will be executed by the CCV Shop system. You do not have to leave your browser on, this process is loaded in the background.

Edit import task

You delete your import task by clicking on the red cross next to the import task.  When you delete your import task and the option 'Work assortment periodically at' has been set to 'Yes', this task will no longer be executed. The products you have in your web store are not removed when you delete the import task.

Options import task

The text below explains the options that you encounter during the creation of your wholesale import task.

Tab Product Options

Delete all existing products / categories:

If you choose "yes" here, all your existing products and categories will be deleted once. This will give you an "empty" web store.

Please note! Products are placed in the trash and categories are removed and can not be repaired.

Default packaging:
Select the default packaging for the products here.

Expected delivery time (when not in stock):
Enter the expected delivery time when a product is not in stock.
(figure 2). 

Update product range periodically: 
Periodically, the following actions are performed:

• New products are added.
• Deleted products are removed.
• The options below are updated on existing products.

The frequency of this depends on the institution you provide.

Periodic update each:
Indicate how often your products / assortment needs to be updated.

E-mail notification for each periodic update:
You will receive a report by e-mail with the changes to the range.

Update product name if edited:
Indicate here if you want to edit the name when making adjustments.

Update product description if edited:
Indicate here if you want to edit the product description with adjustments.

Update price if edited:
Indicate here if the price has to be adjusted in case of changes.

Update stock:
Indicate here whether the stock needs to be updated or not.

Edit product image: 
Indicate here whether the product image should be updated or not.
(figure 3). 

Tab Category options

Create a category within this category
All categories belonging to the selected link are created in the category you selected.

Please note! This option is not available when you choose to delete existing products / categories.

Sort products by:
The way you want to sort the imported products of your import task into the category in which they belong.

Show order button:
With this option you indicate whether you want to display an order button for the products to be imported from your wholesale import task.

Show large image on mouseover: 
Choose whether you want to display a large photo when the visitor of your web store moves the cursor over the photo.

Use canvas style display for images: 
Choose whether to enable the canvas view for images or not.

Number of products per page:
Choose the number of products that are displayed per page in a category. 
(figure 4) 

Tab Lay-out

Default category layout:
Indicate here how the products should be displayed in a category.

Default subcategory layout:
Choose here your view of the products in a subcategory. 
(figure 5) 

Default product layout:
Choose which type of layout you want to use with this option.

Image next to the product description:
Choose how you want the product photo to appear next to the product description.

Display products on offer as offers on pages (modular type or starting page type)
If the wholesaler has indicated that a product is on offer, this product will be displayed as an offer (modular or home pages).

Display products on offer in the webshop:
When the wholesaler has indicated that a product is on offer, this product is displayed in the layout of the webshop. Not every theme has this functionality.
(figure 6). 

Tab available categories

Import selection filter:
This allows you to filter products from certain categories. There you have two options.

• Do not import selected categories: products in selected category will not be imported.
• Import only selected categories: only products in the selected categories are added. Other products are ignored.

Select a category:
Allows you to exclude / select categories (depending on the option set at "Import selection filter"). When you have selected a category, you must press the plus button afterwards. This will then appear in 'Selected categories'. 
(figure 7). 

Base price:
Indicate whether the purchase price excluding VAT or the recommended sales price including VAT should be used here.

Please note! You choose which prices you want to load with this link. If you opt for purchase price excluding VAT, we advise you to add a percentage to the feed prices with price rules, otherwise you may sell for your purchase price including VAT. (Loss!)

Round up prizes:
Determine whether prices have to be rounded or not.

Add price line
Price rules are simple formulas that can be drawn up to address a selection of products or an individual product and to apply a certain price processing. You can define multiple price rules and you can position them. If multiple price rules apply to a specific product, only the first price line will be applied. The price rules are processed from top to bottom. The system helps you to set up valid price rules and keeps track of the fact that you do not draw up double price rules.

Example pricing rules
IF Article number IS EQUAL TO abc123 THEN Base price = € 17.95
IF Brand IS EQUAL TO Philips THEN Basic Price - € 5, -
IF Category name IS EQUAL TO hardware THEN Basic price + 10%
IF Category name IS NOT EQUAL TO hardware THEN Basic price + 20%. 

The above price rules indicate all different types of price rules. Comparisons are made on the basis of category name, brand and article number in which a distinction can be made whether the specified value here must be the same or not equal. The basic price can be increased, equated or reduced by a certain amount. This amount can be a fixed amount or a percentage.

Based on the examples above, for example, you can see that it is possible to reduce all products of the brand Philips € 5, - in price and to give a product with the item number abc123 a fixed price.

Standard price rule (if none of the above rules apply)
Here you can set a standard price rule that should apply if none of the other price rules apply to a product.