Rigid Apps

How do I import a list of my standard products and services?

3 min read By Rigid Apps Editorial Team

Importing your list of standard products and services into Small Business Document Desk is a straightforward process designed to save you time and ensure consistency across your documents. This feature allows you to pre-define items you frequently bill for, making invoice creation significantly faster and reducing data entry errors. You can typically import this data from a CSV file.

Steps to Import Your Product/Service List

  1. Prepare Your Data File:
    • Create a new spreadsheet using software like Microsoft Excel, Google Sheets, or Apple Numbers.
    • Ensure your spreadsheet has clear column headers. Essential headers typically include: 'Product/Service Name', 'Description', 'Unit Price', and 'Unit' (e.g., 'Hour', 'Item', 'Service').
    • A common best practice is to have your data formatted like this:
    Product/Service Name Description Unit Price Unit
    Web Design (Basic Package) Includes 5 pages, mobile responsiveness, and basic SEO. 1200.00 Project
    Monthly SEO Service On-page optimization, keyword tracking, and monthly report. 350.00 Month
    Graphic Design (Logo) Custom logo design with 3 revision rounds. 400.00 Item
  2. Save as CSV: Once your data is organized, save the spreadsheet as a Comma Separated Values (.csv) file. This is a universal format compatible with most import tools.
  3. Navigate to Import Feature: Log in to your Small Business Document Desk account. Go to the 'Settings' or 'Configuration' section, usually found in the top navigation bar or a sidebar menu. Look for an option like 'Products & Services', 'Inventory', or 'Import Data'.
  4. Upload Your File: Click the 'Import' or 'Upload CSV' button. You will be prompted to select the .csv file you prepared from your computer.
  5. Map Your Columns: The system will then display a screen where you match the columns in your CSV file to the corresponding fields in Small Business Document Desk (e.g., 'Product/Service Name' from your file maps to the 'Name' field in the tool). Ensure each field is correctly mapped.
  6. Initiate Import: After mapping, confirm the import. The system will process your file and add all your products and services to your account.
  7. Review Imported Data: Once the import is complete, navigate to your 'Products & Services' list to verify that all items have been imported correctly. Make any necessary adjustments.

Real-World Example: Sarah, a freelance graphic designer, used to manually enter her 'Logo Design', 'Brochure Design', and 'Social Media Graphics' into every invoice. After preparing a CSV file with descriptions and prices, she imported them into Small Business Document Desk. Now, creating invoices takes her less than 2 minutes per client.

Frequently Asked Questions (FAQ)

What file formats can I use for importing?

The most widely supported format is CSV (Comma Separated Values). Ensure your CSV is UTF-8 encoded for best compatibility.

What if I have a large list of products?

CSV import is designed to handle large volumes of data efficiently. For over 5000 items, you might consider importing in batches to monitor the process, though most systems can handle tens of thousands of entries at once.

Can I update existing products during import?

Some systems allow for updating existing entries if a unique identifier (like a SKU or product code) matches. Check the import settings for an 'update existing' option.

What if the import fails?

Review the error messages provided. Common issues include incorrect CSV formatting, missing required fields, or price values that are not numerical. Double-check your file based on the error report and try again.

How often should I update my product list?

Update your product and service list whenever your pricing changes, you add new offerings, or discontinue old ones. A good practice is to review and update it quarterly or semi-annually.

Warning: Information on this site is not a substitute for professional advice. Content accuracy is not guaranteed, and your decisions based on it are at your own risk. External links are not endorsed, and we're not liable for any consequences. Users must comply with laws and respect intellectual property.

Related Content