Working on Your Data Sheet

Watch Video:

If you have a limited character count for your product titles, here we go over how to implement that in your data sheet by first counting the characters in each title, then creating a formula to trim the title down.

Watch Video:

Here we’ll go over how to change all caps on your data sheet into proper format of the first letter of each word capitalized, and how to use the filter to edit information. You want to make sure your data is not in all uppercase, because the all caps will cause problems.

Watch Video:

Sometimes you’ll get data sheets that have leading blank spaces in front of the contents of a box. These extra spaces will often mess up the style on your site and throw things out of whack, or even drop the item completely from being imported on your site. You might also want to merge different fields into one.

Watch Video:

Getting data sheets in various formats is frustrating and if you are not doing this every day you can find yourself not loading a brand because you can't get the file ready to import.

Watch Video:

Getting image urls is a lot quicker and easier of a process than using saved image files. Saved image files get risky to use, so here we go over how to instead quickly add URL’s to your data sheet.

General Site Tasks & Troubleshooting

Watch Video:

Here we go over managing webforms on your Drupal 7 site. How to create webforms and add your recipient email, as well as set up the reply-to email properly. You can either create a webform as an individual page, or add a form as a block to an existing page.

Watch Video:

Here we go over managing two different types of menus in Drupal 7, the OM Maximenu and the default Drupal Menu system. This will cover in detail how to add, rearrange, delete, temporarily disable, and add link paths to both types of menu links. This tutorial uses the main menu as an editing example, but by all means utilize the tutorial for any menu you would like to update.

Watch Video:

While articles and basic pages are added in the same way, articles have a few more fields. Here we go over how to add each of those, and how to take advantage of the different features available in the body of your new page.

Watch Video:
Watch Video:

If your site developer has notified you of site changes and you can't see them in your browser, you may need to refresh both your Drupal cache and your browser's cache. Note that all caches refresh automatically every few hours.

Watch Video:

This tutorial will go over how to delete and add slides; then how to add text, images, links, and videos to MD Silders, which are mostly used for site banners for Drupal 7.

Working With Your Importer

Watch Video:

This tutorial will go over how to create product displays for a data sheet you might have just imported. These instructions will show you how to create product displays for several products at a time, instead of making them one by one.

Watch Video:

At this point, we are assuming that you’ve already prepared your data sheet and checked for missing fields. This tutorial goes over mapping, tampering, and importing.

Watch Video:

This involves a lot of focus. Before starting to prep your sheet, try to make sure you are not going to be interrupted. A mistake made in your data sheet means you will be importing junk onto your site. The goal here is to make sure all necessary fields have an entry, and that all entries are valid.

SEO

Watch Video:
Watch Video:
Watch Video:

Working With Products & Data

Watch Video:

How to use the taxonomy manager to manage featured brands and categories and adding images in Drupal 7.

Watch Video:

These instructions should help speed up your importing process by cleaning up CSV sheets to import neatly. This covers how to search for duplicate values, missing/blank fields, trimming data to get rid of leading spaces, and more.

Watch Video:

There are 2 ways to list your products on eBay. You can either list one at a time, or list several products in bulk. It’s a simple process, since the eBay module does most of the work for you. Here we go over how to work with it.

Watch Video:

These instructions will go over how to find and manage auto-generated order e-mails.

Watch Video:

Here we go over how to view your pending orders and process them officially. This is also where you can add tracking numbers, and this tutorial also covers how to add new carriers if they aren’t already listed for you.

Watch Video:

Fitment is important, since your site is most likely an auto-parts site. If you’re using ASAP then the fitment will be auto-loaded for you, but not all manufacturers will give you the fitment. Here we go over how to add the fitment yourself.

Watch Video:

If you want to have a product filter for users on filtering by vehicle type, color, etc., there needs to be a target field that you can map the source to. Your site does not automatically filter by itself. That’s like asking a plumber to fix a sink you don’t have. It’s simply impossible unless you buy the sink. Luckily that field is easy to set up, but remember that you need to have it in order to get filters.

Watch Video:
Watch Video:

As your inventory grows larger or if you happen upon a new item that needs to be sorted into a not yet existing category, you can add that category to your Drupal site through a few steps.

Other Site Content

Watch Video:

The main difference between the two is that coupons are only applied using some kind of code, discounts can be added to a product or an entire order and are automatically applied by the system. Here we’ll go over how to add either of those to your sites store.

Watch Video:

This video will help you think outside the box with your e commerce site. Hope you find some jewels for success here.

Watch Video:
Watch Video: