Woo Commerce Spreadsheet:
OmegaNet, Inc. is building B2C retail websites using the Woocommerce software platform. Click on this link to see an explanation of the column headers on a Woo Commerce (WP) spreadsheet. https://docs.woocommerce.com/document/product-csv-import-suite-column-header-reference/
Uploading Images in a Word Press retail site dashboard:
WordPress can accept images in the .jpg, .png and .gif format. In the Word Press Admin Console select Media then click on Add New. Choose the file from your computer and then click on the Upload button.
To add this image to a product in the the database click on Products in the sidebar, Search by Sku number in the top right hand corner and click on the Edit button below the product. You are now looking at the product record on the server. Scroll down to the bottom right of the screen and click on Set Featured Image (you may also change the image by clicking on Remove Product Image), click on the image from the Media Library and then click Set as Featured Image. Click here to more on how to add images.
Adding and Managing Products in the woocommerce retail site dashboard:
Select Products from the left hand sidebar in the dashboard. Click on Add Product and a new screen will appear. Give the product a name in the Product name field. In the large box below the Product Name field type in a product description.
Select the main Category and subcategory (if applicable for the product) by going to Product categories on the right hand side of the screen. Click on the boxes that apply to the product’s category – you can select multiple categories for a product.
Next scroll down, click on the Inventory button and add a SKU number. Add the product’s Price by clicking the General button. Click on Shipping (just to the left) and add the weight and dimensions of the product if you are using FEDEX or UPS. If you set a flat rate for shipping there is no need to add the weight or dimensions. In the Shipping Class you can leave No Shipping Class as the default.
To add an image for this product scroll down and click on Set Featured Image (right hand bottom of the screen). Click on the image for this product from the Media Library (see instructions above for uploading an image) then click on Set Product Image. Multiple images of a product can appear on the website by clicking on the Add product gallery images button. Click on the additional images for the product in the Media Library. To add several images at a time click the shift key and click on each additional image. Click on the Add to gallery button.
The last step is to click on the Publish button (top right hand side of the screen) to make the product visible on the web site. Click here to view how to manage products
Editing a Product in the Word Press retail site dashboard:
Select Products from the sidebar, search for the product, put your cursor on the product name and click on the Edit button. Change the information on the screen for this product. Click on the Quick Edit button to make minor changes such as the price, sku number and category choice. Click on Update on the top right hand side of the screen and the new information will appear on the web site.
Grouping Products in the Word Press retail site dashboard:
Often a product will have options such as different sizes or colors. The first step is to add the product to the database (see above). In the record in the Product data field click on the black down arrow and choosed Grouped product. Click Update.
Go back to the products screen and search for that product record. Click on Duplicate below the product’s image on the products screen. Be sure to remove the word (Copy) from the product name. All of the information is duplicated except you must change the SKU Number. Click on Linked Products to the left of the products price (change the price if it is different for this option) and click on the dropdown menu in Grouping. Enter three or more characters in the product name and click on the selected group name. You do not have to enter a category or subcategory for products you are grouping under a main Group title. Next click edit next to the Category visibility (top righthand side of the screen and select Hidden. Now click on Publish. In this way products with the same image and product information can appear together on the web page. Customer will see View Products under the product image and can select which option in that product they would like to order.
Adding Attributes in the Word Press retail site dashboard:
A product may have options such as color choice or pattern and this is called a product attribute. You can create a product with attributes after a product is added to the database. The first step is to set up product attributes by clicking on the Attributes link in the sidebar. A screen will ask you give a name, for example Color, to attributes that will be used for certain products. Next enter the values of the attributes such as gray, green, blue or the sizes.
When a product has Attributes it must be selected as a Variable Product in the Product data field. After the product attributes are added click on Variations. Next click on Add Variation from the dropdown menu and click Go. Variations can be color, size, style and so forth. Once the variation(s) are created click on the word expand to add the sku number, price and indicate that the product is in stock. Note: if the price is not added here the product will show up as out of stock on your retail website. Click here for more information on Variables. Click on this link for more information: https://docs.woocommerce.com/document/variable-product
Adding a Coupon Code
Online shoppers are looking for the best prices on products. To offer a special discount coupon to these buyers click on WooCommerce on the left side of screen and then click on Add coupon. Give the coupon code a name which the customers will use at checkout and add a description. Next click on the black down arrow across from coupon data and select the type of coupon you wish to add.
The choices are percentage discount, fixed cart discount and fixed product discount. The general tab provides you with the opportunity to select one of these options. The percentage discount give the buyer a percentage discount on their entire order. A fixed cart discount coupon code used at checkout gives the buyer a percentage off their entire order. A fixed product discount is for certain products and the coupon code gives this discount at checkout. In the Coupon amount field enter the percentage discount such as 10 for 10%. If the coupon code is for free shipping then be sure there is a free shipping method added to your shipping methods. Next add the expiration date for the coupon.
Click on the Useage restriction button and add a mimimum amount the buyer has to purchase and it choose Individual use only if the coupon can not be used in conjunction with other advertised coupons. If fixed product discount is the type of coupon then add the products it pertains to in the Products field. Type in the first 3 letters of the product name and it will appear. Select several products where the discount code applies. Select Product categories if the coupon applies to an entire category and not selected products. Click on the Useage limits if a buyer is limited to the number of times the coupon can be used. Click the Update button on the right hand side of the screen and the coupon is ready to be advertised to the buyers. Click on this link for more information about coupons https://docs.woocommerce.com/document/coupon-management
Managing Orders in a Word Press retail site dashboard:
Click here to view how to manage orders.
Woocommere Settings