A complete Guide For Invoice Converter Tool

## 📖 A Complete Guide to the Universal Invoice Converter Fields

Welcome to the Universal Invoice Converter! This guide will walk you through every field on the editor page, explaining what it does and how it maps to popular e-commerce platforms like Shopify, WooCommerce, and Vend/Lightspeed. Understanding these fields is the key to automating your product creation process and saving hours of manual work.

## 1. Invoice Information

These fields are at the top of the editor page and contain general information about the invoice you are processing.

• Supplier: The name of the company or vendor that sent you the invoice. This is often used as the default “Vendor” for all items.
• Invoice Number: The unique identifier for the invoice (e.g., “INV-12345”). This is used for your own record-keeping.
• Invoice Date: The date the invoice was issued.

## 2. The Tools Section: Bulk Editing & Pricing 🛠️

This section contains powerful tools to apply changes to all of your items at once, saving you from repetitive editing.

• Set Selling Price Margin (%): This is for calculating your retail price based on your cost. Enter your desired profit margin percentage here.
  • How it works: If an item costs $10 and you enter 80 in this box, the selling price will be calculated to $18.00 (an 80% markup). If you want to double the price, you would enter 100.
• Bulk Edit Collection/Category: Enter a name here and click “Apply to All” to set the same collection/category for every item in the list. Just use the same name you have in your CMS like Shopify, woocommerce or other platforms, check carefully before entering the value, otherwise it will create new.
• Bulk Edit Vendor: If the supplier is different from the product brand (e.g., you buy Nike products from a distributor), you can enter the brand name here and apply it to all items.
• Bulk Reorder Point: Set a default reorder point for all items. This is the stock level that should trigger you to order more.
• Bulk Restock Level: Set a default restock level for all items. This is the ideal stock quantity you want to have after reordering.
• Outlet Name (For Vend/Lightspeed): This field is critical for Vend/Lightspeed users. You must enter the exact name of your outlet (e.g., “Main Store,” “Warehouse”) as it appears in your Vend account. The inventory columns in the final CSV will be named using this value.

## 3. The Items Table: A Field-by-Field Guide

This is where you’ll fine-tune the details for each product. Here’s what every column means and how it’s used.

Field Name	Description & How to Use	Platform Relevance
SKU	Stock Keeping Unit. A unique code for each product variant. It’s the most important field for tracking inventory. Use the item number from your invoice.	Shopify: Variant SKU WooCommerce: SKU Vend: sku All Platforms: Critical for inventory.
Description	The product’s title or name. This should be clear and descriptive for your customers.	Shopify: Title WooCommerce: Name Vend: name All Platforms: The main product name.
Qty	The quantity of this specific item you received on the invoice.	Shopify: Variant Inventory Qty WooCommerce: Stock Vend: inventory_[Outlet Name] All Platforms: Sets the initial stock level.
Cost	Your cost per item. This is the price you paid the supplier for a single unit. It’s used to calculate the selling price and your profit margins.	Shopify: Cost per item Vend: supply_price QuickBooks: Cost Note: Not visible to customers.
Price	Your selling price. This is the retail price your customers will pay. It’s automatically calculated when you use the “Set Selling Price Margin” tool.	Shopify: Variant Price WooCommerce: Regular price Vend: retail_price All Platforms: The customer-facing price.
Collection	The collection, category, or group the product belongs to (e.g., “Hats,” “Summer 2025,” “New Arrivals”).	Shopify: Type (also used for collections) WooCommerce: Categories Vend: product_category
Tags	Keywords used to help customers find products and to organize your store.	Shopify/WooCommerce: Separate tags with a comma (,) e.g., hat, summer, adjustable Vend: Separate tags with a semicolon (;) e.g., hat; summer; adjustable
MPN	Manufacturer Part Number. A code created by the original manufacturer to identify the product. Important for electronics, parts, and hardware.	Shopify/Google: Google Shopping / MPN BigCommerce: MPN Note: Great for SEO and product feeds.
GTIN	Global Trade Item Number. This is the product’s barcode number (UPC, EAN, ISBN). It should be a string of numbers.	Shopify: Variant Barcode Google: gtin BigCommerce: Product UPC/EAN Note: Essential for Google Shopping and marketplaces.
Vendor	The brand name of the product (e.g., “Nike,” “New Era,” “’47 Brand”). This defaults to the supplier name but can be changed.	Shopify: Vendor Vend: brand_name / supplier_name
Variant Title	If a product has options like size or color, this field defines the specific option for this row. For example, “Medium,” “Large,” “Blue.”	Shopify: Used with Option Names Vend: variant_option_one_value Note: Leave blank for products with no variants.
Variant Barcode	The specific barcode (GTIN/UPC) for this particular variant (e.g., the barcode for the Medium size might be different from the Large).	Shopify: Variant Barcode Note: Overrides the main GTIN field for this specific variant if filled.
Reorder Pt.	Reorder Point. The stock level that should trigger you to order more of this specific item.	Vend: reorder_point_[Outlet Name] Note: Critical for inventory automation.
Restock Lvl.	Restock Level. The ideal quantity of this item you want to have in stock after placing a new order.	Vend: restock_level_[Outlet Name] Note: Helps you know how much to order.