Inventory is the module we place all Hardware & Services in that you might sell. It's both a primary tab on the site navigation, and an overarching concept that includes Purchasing, Vendors, Purchase Orders, Stock Take, and lots more.
Table of Contents
- Inventory Settings
- Organizing Inventory - Category Editor and Tabs
- Adding a Product
- Upsell Opportunities
- One Time Use Products
- Inventory Import / Bulk Editing Inventory
- Purchase Orders
- Pending Orders
- Electronic Ordering
- Customer Purchases
- Stock Takes
- RMA / Returns - tracking
- iFixit - Product Catalogs
- How do I add a SKU?
- What is the difference between Parts and Inventory?
- How do I delete an inventory item?
- Can I add serial numbers to my inventory?
- How do I show the cost of my inventory items?
- Can I Bundle Items in RepairShopr?
What Inventory Does
- Tracks the items (both products and services) that you will sell
- You can choose to maintain stock at the item level
- Fully Serialized - meaning we track down to the individual instance
- You can store individual serial numbers on each item if you want
- Batch Tracking from Purchase Orders ties instances to Vendors
- Set reorder level, desired quantity, cost, retail, categories, tons more
- One-Click electronic ordering available for select vendors
- Pending Orders page - All your reordering in one place
What it Doesn't Do
- Variants like Size: Small, Medium, Large (you have to just duplicate the item)
Inventory Training Video
Here is a breakdown of the Inventory Preferences
|Send a daily Low-Inventory email||A daily email is triggered to your main account email address that shows you all Low-Inventory Items.|
|Enable Wholesale Pricing||Allows you to sell Inventory Items at cost|
|Enable Purchasing from the public||Allows you to purchase Inventory items/parts from your Customers. For more information, refer to this article.|
|Enable One-Time-Use Inventory Items:||Enables the "One Time Use" checkbox on Inventory Products that will set them to be disabled once the stock runs out. You can read more about how to set up and use this by visiting this article.|
|Enable Percentage Markup:||Turning this on allows you to set a Margin (Profit) percentage for New Products being created at the account level and the individual product level.|
|Show Categories (overridden to enabled if using PrePay Hours or Deposits)||If you want to hide "Categories" uncheck this box|
|Enable the PrePay Hours tracking feature (also a Customers setting):||Allows you to sell Pre-Pay hours to customers, learn more about this feature here: Pre-Pay Hours|
|Enable the Deposits feature (also an invoice setting):||Check this box if you take "Deposits" for services or products. Learn More Here!|
|Show Top-Level-Categories as Tabs (only when no search query):||Check this box when you want to show your categories as top-level selectable tabs in your Inventory Page. Try it out :)|
|Enable Photos on Products:||If you want to be able to attach photos to a product inside your inventory check this box|
|Enable the Back-order feature:||This will trigger the system to create pending orders when you are out of stock on an item. Pending orders can then be placed on a Purchase order and quickly fulfilled.|
|Use Basic Labels instead of Instance Labels on non-serialized Products:||This toggles Basic Labels as the default labels and hides the In-Stock Label.|
The Category Editor allows you to organize all of your products and services by a particular category or sub-category. Product Sales Reports only pulls information by category, so using this tool is perfect for getting granular data on what your shop sells the most.
Organizing Inventory - Category Editor and Tabs
RepairShopr has support for multiple levels of categories.
To edit these, go to Admin > Inventory Preferences.
Here you can enable these with the Show Categories option. This will then give you a category tree you can customize:
In addition, you can enable tabs at the top of your Inventory page to make organizing and sorting inventory easier.
The suite also lets you organize your POS with category drill-downs. To enable this, go to Admin > POS Preferences:
Your POS inventory will now show with high-level categories:
Adding a Product
Click on the "Inventory Tab" and then click on the green button that says "New Item" to get started.
What these fields do
|UPC Code||This is where you will add your own Universal Product Code(UPC). Our system will generate a barcode for you using this number.|
|Retail Product or Service:||Indicates that the item is a product or service|
|Discount - Amount/Percent:||Use this if you want to create a Percentage discount that can be added as a line item on an invoice. Categorize this as a discount and it becomes a trackable item in your "Product Sales Report"|
|Price Retail:||The price for your customer.|
|Price Cost:||What you paid to purchase this product|
|Taxable:||This checkbox indicates whether the item is "taxable" or not. Leave it unchecked if the item should be tax-free|
|Notes:||This is a box to add any notes that will be used internally for this product.|
|Maintain Stock:||Checking this box will allow you to track quantity, order from purchase orders, and get alerts when an item is running low on stock.|
|Serialized:||Check this box if you have items you would like to track using a serial number.|
|One Time Use:||Check this box if you would like the system to disable the product once it reaches a quantity of 0|
|Re-order At:||This will trigger a pending "Low Stock" request and will alert you if you have a notification set.|
|Desired Stock level:||The system will create a pending order to bring you back to this "desired stock level" when you hit your re-order point|
|Quantity:||This is the number of items you have in stock|
|Category:||You can categorize items to organize them and certain categories will trigger other features in the system e.g. "Labor", "Pre-Pay Hours", "Deposit"|
|Sort Order:||This allows you to set certain products into a higher position on your inventory list so that they are easier to find. Users will sort by order of importance|
|Physical Location:||Where the item is located physically in your shop|
|Condition:||The condition the item is in e.g. "New" or "Used"|
|Warranty Template:||This will allow you to assign Warranties to Products so that when the product is sold the Warranty gets added to the customer's record. You will need to create a warranty template first to use this feature. Learn to create warranty templates here!|
To use Upsell Opportunities on products in Invoices, Estimates, or the POS, you will need to enable the feature in the Preferences for any of those three. Then visit a Product Detail page of any product in your inventory and click the Upsell Opportunities tab.
Once on the Upsell tab, there are two fields to choose from.
1. Search for individual Products.
2. Choose entire Inventory Categories to have shown when the item is added to an Invoice, Estimate, or the POS transactions.
Once you have added your individual products or your categories hit Save. At that point going forward, whenever the product is added to an Estimate, Invoice or POS (depending on which you have turned on their respective preference section) will have a pop up asking if you want to add additional items to the transaction.
One Time Use Inventory Products
One Time Use Inventory Products are products that you have on-hand and want to sell to customers, but you do not want to consider them a permanent part of your Inventory and re-stock them when you run out.
How to use
First, get started by enabling this at Admin > Inventory > Preferences > Enable One-Time-Use Products, shown here:
When you create a new Inventory Product or modify an existing one, you will be able to see the checkbox for One Time Use items here:
You will also see the "One Time Use" checkbox when adding a new Manual Product to a Purchase Order.
Click on the "Manual Add" button in the Purchase Order next to the "ADD 'MAINTAIN STOCK' PRODUCT FROM INVENTORY" box, then you will see the checkbox at the bottom of the pop-up window:
Things to note
Back-ordering a One-Time-Use Product is not recommended as they are designed to be disabled and not re-ordered
Inventory Import / Bulk Editing
Table of Contents
When you have multiple edits or additions to make to your inventory, the best way to do that is to export your inventory to CSV, make the changes in Excel (or Google Sheets), and then re-import it back into our application.
The buttons for exporting and importing are located in the Inventory Modules button at the top right of the Inventory page:
- Unless you've exported your inventory from our software and it's an existing product (already in your current inventory), the 'id' column should be left blank.
- If you are adding items with quantity, make sure the 'maintain_stock' column is set to TRUE.
- If the item is taxable, make sure the 'taxable' column is set to TRUE.
- If you are using product categories, make sure those categories have been created in our software before you import the inventory.
- If using Big-Chain: You can leave the 'quantity' column blank, but make sure to fill out the individual location's quantity on the CSV.
- Don't use the $ symbol when filling out cost and price.
- If your UPC codes are long, make sure that Excel isn't shortening them using scientific notation prior to importing.
- If delete is TRUE and there is an id that matches, that product will be deleted completely.
- The name of the product should be unique.
- Additional fields are listed for Big Chain accounts and can be seen by exporting the current inventory.
CSV columns breakdown
|id||Do not edit the values in the id column! Inventory items that are already in the system will have a unique value that our software has generated. Leave that value blank for items that are brand new.|
|name||This is the main name of the item. This is a required field.|
|description||This describes the item in more detail. This field is searchable. This is a required field.|
|maintain_stock||This is used if you wish to have our program keep track of the item's quantity, so if 1 out of 3 items are sold, the software will adjust the quantity to 2. TRUE or FALSE|
|quantity||How many you currently have in stock. Make sure that you have maintain_stock set to TRUE if you're tracking quantity for the product. If you leave this blank, it will default to 0 on any items marked for maintain_stock set as TRUE. If you have a Big Chain account with multiple locations, you will need to find the quantity columns for each location, such as "Portland-quantity", and update those instead.
|condition||You can set this to "used" or any other condition you wish. This is useful if you're purchasing from the public and refurbishing/re-selling items and need to track which are new and used.|
|warranty||Use the warranty_template_id column to update the warranties attached to products|
|created_at||This is system driven and shouldn't be edited unless you specifically need to.|
|updated_at||This is system driven and shouldn't be edited unless you specifically need to.|
|sort_order||Allows you to set which page of the POS system the item will be assigned to. Adding a lower number here will also have the item appear first in the default list.|
|disabled||Set this to TRUE to disable an item in inventory, set to FALSE to show the item in inventory.|
|reorder_at||This number will specify how low of a quantity you want an item before it is considered "low stock." This is useful in Purchase Orders.|
|taxable||Marking this TRUE or FALSE will mark apply/not apply your tax rate to the item when it is sold.|
|upc_code||This is a searchable code that can be typed or scanned. You can either make one up or use the item's existing UPC code.|
|discount_percent||If you have a discount inventory item, what percent is it?|
|warranty_template_id||If you have an existing warranty template (Admin > Warranty Templates), you can copy the number from the URL when you edit the template, and paste it here to apply that template to an inventory item. Information on warranty templates are found here: Warranty Template Knowledge Base article|
|vendor_id||The Vendor ID identifies the vendor and is assigned by the system.|
|desired_stock_level||The ideal amount of QTY you'd like the inventory to be at. This is helpful for re-ordering stock.|
|notes||Notes can be applied if an item has any special information that needs to be on the record. These notes are visible from the product detail page but are not visible in other locations|
|tax_rate_id||You can add multiple tax rates in Admin > Invoices > Tax Rates. You can edit any of your tax rates and copy the numeric identifier from the URL on the edit page and place it here to apply that tax rate.|
Select TRUE if you want the item to be serialized, FALSE if you don't. If you make a product serialized you can not later mark the product as FALSE.
This description is used in conjunction with the WooCommerce integration and is not visible as a template tag within the software.
Set to TRUE if you would like to make an item a One Time Use item. Information on one-time use inventory products are found here: One Time Use
Set to TRUE if you wish to permanently delete an item. This is not recommended, we recommend you disable items.
The amount you are selling this item for.
The amount this item costs you.
If you have enabled the wholesale pricing feature you can set a secondary retail price for a product.
If you had added categories, or wish to categorize your inventory with the default categories, type which category the inventory should go into. Note: You can edit/view categories in Admin > Inventory > Preferences.
Head over to your Admin > Vendors page and copy the vendor name into this field. If you have vendors applied to your inventory, you can easily create and submit Purchase Orders.
Serial numbers go here for each product
Troubleshooting Inventory Imports
If your import is failing in RepairShopr go to Admin > Reports > Import results (top right) and see if there any errors appearing. Generally, if you have a low percentage of failures, it's just some bad data in the import file. It the percentage is over 20% the file probably needs to be adjusted to fit our format.
The error summary is grouped by the fields that failed validation, so if it says: "email, phone, mobile invalid:" that means those records failed all of those fields at the same time. That could mean you have those fields marked as required in the settings, but they weren't found in the CSV.
Long UPC numbers
These may not display properly in Excel, as Excel automatically shortens long numbers to scientific notation. You may want to turn off this option, as importing a CSV with scientific notation into the software will not store data properly.
If you think your CSV file has all the right fields, but your import doesn't load inventory, try uploading your CSV to this test site and see if the columns are correct: http://csv-validator.herokuapp.com/.
Create and Send Purchase orders on the fly in the Purchase Order Module of your account.
First, create a Vendor
You will want to have your Vendors already entered before you start creating purchase orders.
Vendors are companies that you can source parts and inventory from. You can create Vendors and assign them to Inventory Items as well as Purchase Orders to better track where your parts are coming from.
1. Head over to ADMIN > Scroll down and click Vendors on the left side under the "Inventory Sub-Section".
2. Once there you can Create a New Vendor by clicking on the "New Vendor" Button
3. Fill out all of the appropriate fields and click "Create Vendor" and you are all set!
4. The Vendor Profile will look like the image below and you can reach it at any point by clicking on the vendor's name highlighted in blue.
Creating a Purchase Order
Only items that have "maintain stock" checkbox, checked can be ordered through the Purchase order module.
1. Go to Purchase Orders and click New Purchase Order.
2. Select the Vendor from the drop-down and fill in the other fields that apply
Add items to your PO here and update Shipping Charges as needed:
DELIVERY TRACKING NOTE: While not shown in the New Purchase Order image above, we have added a Delivery Tracking field that you can enter tracking information either during the initial PO setup or while editing an existing PO and it will be linked per the following guidelines.
- If a tracking item by itself is entered into the field it will try to use a Google search to find it.
- If multiple items are entered separated by commas or spaces (like abo322,aoosi29,aouia22) it will treat it as text.
- If a URL starting with http:// or https:// it will be treated as a web link.
3. Click on the green "Create Purchase Order" button. It will bring you to a page that looks like this.
Adding a product to a Purchase order
If the product is not already listed on the PO, add it by searching for it in the Name field. You can also create and add a product using "Manual Add"
Once you have listed all of your products, click the Email Vendor button to submit your order. This will put the PO in "Ordered" status.
When the order arrives, change the status to Check-In to receive the items into Inventory.
- You can choose to receive all items at once or go by line item. For serialized items click on the orange button to add serials.
- Once you have received all of your items the system will change the status of the PO to finished and you're set!
Import/Export Purchase Orders
First head to an existing PO and choose Actions then Export to CSV
Next, open the CSV file to make edits or add more line items
Important to note - When importing the CSV back to the system, make sure that you have at 1 of the 3 following items: Product ID, UPC or Vendor SKU
When the CSV is ready to head back to the system and create a new PO. Then click Actions > Import.
You will see a familiar upload page that is similar to the other upload sections in the software.
Remember you need 1 of the 3 following items: Product ID, UPC or Vendor SKU on the CSV in order for it to import successfully.
Once you have processed your import, the line items will show up on the PO and you can send it off to the vendor!
Pending orders page allows you to view and fulfill orders created through the low stock triggers and pending orders triggered on invoices.
What it does
- Automatically triggers pending orders based on stock levels
- Allows you to add pending orders or low stock to an existing or new Purchase order
- Track Pending and Low Stock orders on one page
- Fulfill orders on invoices after the check-in step of a purchase order
What it doesn't do
- Order the items automatically
- Enabling Pending orders
- How Pending orders work
- How Low Stock works
- Adding Low stock / Pending orders to Purchase orders
- Fulfill Pending order on an invoice
Enabling Pending Orders
To enable Pending orders: Go to Admin > Inventory > Preferences > Additional Settings > Enable the Backorder feature > Save
How Pending orders work
Once the Backorder feature is enabled, it will deduct your inventory past 0 into the negative quantities, these negatives will then show up on the Pending orders page.
[Image needs to be updated]
How Low Stock inventory works
Adding Low Stock & Pending orders to a Purchase order
To do this go to the purchase order you wish to add these items to. Below the PO details, you will find three options Add All Low stock items, Add Low Stock by this vendor, Add all pending items.
|Add All Low Stock Items||Add All Low Stock Items by this Vendor||Add All Pending Items||Email to Vendor|
|Adds all items that are below your desired stock level||Adds items that are below your desired stock level for a particular vendor only||Adds all Pending Orders to the Purchase Orders, to learn more follow this link||This will trigger an email of your purchase order to the vendor to start the order process|
Fulfill Pending orders on invoice
You can fulfill a pending order on an invoice by going to the invoice > Clicking on the quantity that is marked pending on the invoice > Add the pending order to a Purchase order > and receive the item in the Check-In stage.
When you receive those items on a PO, you can click Fulfill to allocate those items to your existing pending orders (instead of moving them to "In Stock" in your inventory).
What it doesElectronic Ordering is used when purchasing parts and products online from a vendor that uses our software. You can also use it to sell parts and products to other users.
Electronic Ordering is used when purchasing parts and products online from a vendor that uses our software. You can also use it to sell parts and products to other users that use our software.
Turn on Electronic Ordering
To get started, navigate to Admin > Inventory > Preferences, then find and check the box labeled: "Enable RepairShopr to RepairShopr electronic ordering" shown here:
Once it's enabled, just follow these steps to use the feature:
As a Vendor
1. Create a new customer (or modify an existing customer) that you'd like to sell to.
2. Edit the Customer and select the "Additional Fields" tab along the top. You will see a field where you can add in their account subdomain.
3. Have a list of products ready with the UPC codes and prices in a format for this customer to add the products to their inventory. The customer will use the UPC as their Vendor SKU.
4. When the customer sets up their end you will get an invoice with the products they added to their Purchase Order.
5. You will have to confirm the invoice details are correct (just like any other invoice) and send an email for payment.
6. Once payment is received you can ship the items.
As a Customer
1. Create a new vendor (or modify an existing vendor) that you'd like to buy from.
2. Edit the Vendor and add their account subdomain to the proper field.
3. Add or modify existing products with the information provided by the Vendor. You will use their UPC as a Vendor SKU. To do this go to Inventory> Select the Product you would like to order > Edit > Scroll down to "VENDOR SKUS"
4. Create a Purchase Order, attach the Vendor, and add items that you would order from them ensuring the Vendor SKU is present.
5. Electronically process with the Vendor. >It will create an invoice on their system and leave a note for the Invoice number.
7. The Vendor will confirm the invoice details are correct and send you an email to request payment.
8. You can then receive the items and make sure Purchase Order is accurate and matches the invoice.
Customer Purchases allows you to buy devices from Customers, and then track the Item's status if any refurbishing is needed before adding it to your Inventory as a ready-to-sell Item.
First, you'll need to enable Purchasing from the public, in Admin > Settings > Inventory Settings:
Once that is enabled, you'll have a new Purchase Receipt Template in Admin > Templates:
These Receipts are meant to store the details of what you bought, plus the identification of the person you bought it from - and give you an easy receipt to hand them.
After enabling Customer Purchases, you'll be able to access it in Invoices > Customer Purchases:
From there, you can create a new Purchase, or Modify existing ones.
To create a new Purchase, you'll need to begin by finding or creating a new Customer.
After doing so, you'll be taken to the new Purchase screen.
At the top, you'll find the Purchase Details, including basic Customer information including their ID number. You can also set the Status of the Purchase, add General Notes, and Attach a File. Attaching a file is often used if you'd like to keep an image of the Customer's ID, or an Image of the original device on record:
Below Purchase Details, you'll see Purchase Items. This is where the Items/devices will appear when you add them as you'll find below:
After adding the item(s) to the Customer Purchase, you'll have the ability to add notes in the Comments/Notes field and see the history of your notes in the Log to the right. Notes are intended to be used along with the Status drop-down, for tracking the progress of the device before it is added back to your Inventory.
Once you're finished adding the items, you can generate a PDF of the purchase, and Pay Out:
You'll then be taken to the Take Payment screen where you can define the payment method:
* If you have a Payment Method of type 'Store Credit', you can record the purchase as a credit to that Customer for later use on Invoices.
That's it! You have now taken payment and can either immediately add the Item to your Inventory, or use the Status to move the device through refurbishing before it is ready to sell:
Back to Table of contents
Our Refurbs Module is an expansion of Customer Purchases, to let you track inventory usage while you get items purchased from customers ready for sale.
Here is a video highlighting the Refurb flow:
What it Does
- Send a Customer Purchase into the Refurb workflow
- Add parts/labor/notes/etc to things you buy so you can track the work
- Adding inventory items to Refurbs will take those items out of inventory
- The "cost" (what you paid, not retail) will automatically adjust based on the items you put into the device
What it Doesn't Do
- It's currently just based on the Customer Purchase and Parts module - we are open to feedback about other items that should be able to get into Refurb
The Refurb module is used to Refurbish or restore a product that is purchased either from a Customer or from a Vendor so that it can be resold. Some businesses aren't able to truly know the cost (or time) needed to restore that specific machine and that's where the Refurb module comes in. This module thus allows you to accurately track the total cost of the refurb and will apply it to that specific inventory instance cost.
Here's an example common use case:
- The shop buys back a Desktop from a client and issues them a new one.
- The shop then determines that the desktop could still be used by another client.
- The desktop gets sent to the Refurb module because it needs to be cleaned physically and the HDD/SSD needs to be wiped and the OS re-installed/re-imaged.
- Once the desktop is added to the Refurb module and a tech begins their work on the desktop, they can add labor to the refurb tracker so the Store knows about the time and cost that has been invested.
- You can optionally also choose to use products from your inventory if you are needing to upgrade RAM or replace a drive and the cost will be added to the product instance cost.
- Once the refurbishment is complete, the product can be sent back to available inventory so it can be issued (sold) to a new client.
When purchasing an item from a customer, you'll see a new button at the end of the flow:
Clicking this button brings up a modal asking for a description of the issue. This description is used as a short identifier of the kind of work needed. You can enter notes as you go later, so keep this brief.
Once you submit the issue description, you will be taken to the new refurb, which is full of information about the item you're working on.
You can add items you used to work on the product in this form on the right, including labor and one-off items that you don't generally track. Anything you add will be reserved for this refurbishment at this point, so available quantities of stocked or serialized items will decrease.
For items added that already have a cost specified, you will not be able to update the cost, but for one-offs and labor, you can adjust the cost value to reflect each case.
In this example, the adapter is an inventory item supplied through purchase orders, so we know how much it costs.
Once you're ready, you can hit the big green 'Complete' button to add your new item to inventory. The cost of that item will reflect the effort and goods you spent on it, and the items used will be subtracted from your inventory.
Stock Take - Inventory Reconciliation
Our Stock Take module can help you go through and verify your actual stock on hand matches the on-hand value shown in the Inventory tab. It will also allow you to update the on-hand value in the system to match your inventory count when discrepancies are found.
To access the Stock Take module, head to Admin > Stock Take.
Stock Take Lists
First, you probably want to set up a "Stock Take List" of items to be checked.
This can be a random sampling of your inventory, the whole inventory, or a subset based on category or high-frequency sales.
To do that click Inventory Modules > Stock Take Lists > New Stock Take List
Next, tell it what products you want to be checking when you run this List
Now that you've told it what products you want to check, you can go do a stock take. Click "New Stock Take" there to begin checking stock. You can do this from the Stock Take List overview or from the Stock Take List edit screen.
After starting a new stock take, you will be taken to the stock take main-screen. From here, we have a few different ways to enter your stock in an attempt to make it as fast as possible for you.
The fastest mode is barcode scanning. You can get a barcode scanner (USB or Bluetooth/mobile) and just scan every product you want to count. The site will make success/fail sounds so you can concentrate on what you are scanning.
If you scan some items that aren't able to be found, they'll show up in the top list of "Recent Scans" - but not in the entries for the batch area.
If you want to fallback to keyed entry, you can search for a product and enter quantities - then switch to another product. When using the keyed entry mode, the page looks like this:
You can type quantities and hit enter for speed. If on an iPad/tablet, you could also use the onscreen keypad. (1-9, since it auto-submits - no 0).
When ready to move to the next item click "change".
Note that your progress is saved as you go, so you can always navigate to a different page and then return to this stock take to continue entering data.
Once you have completed your inventory count and want to finalize the results, click the Finalize button at the top of the page. This will take you to the "Resolve Stock Take" step in the process.
On the Resolve Stock Take page, you will see several pieces of information: (this requires a separate permission)
- Expected Quantity: this is the current on-hand quantity for each item in the Inventory tab.
- Counted Quantity: this is the value entered during your inventory count.
- Update to Counted: this is a series of checkboxes for each item in the stock take. Any items that have this box checked will update the on-hand value in the system to the value seen in the Actual Quantity of the stock take once the stock take is submitted.
- Reconciliation Reason: A note about why you think the count was off
- Notes: Another notes field
NB*: if you don't tick the "Update to Counted" checkbox the product quantity will not be updated.
After reviewing the information and selecting the items to update, click Submit to finalize the stock take. This will set that particular stock take to a "read-only" state so that it can be reviewed, but not revised.
Here is an example of the report you get from a finalized Stock Take
If you click + New Stock Take and get the error "Location cannot be blank. Please select your location." you must set the location you are in from the user menu.
- Click your username in the upper right > Change Location.
- Click the desired location where you want to take stock.
- Go to Admin > Stock Take.
- You can now successfully click + New Stock Take.
RMA/Returns Manager - Tracking
Index for Returns Manager
The Returns Manager is where you can track products that have been returned that have not yet been added back to inventory or need to be sent back to vendors for various reasons like RMAs.
To start, head to the Inventory Tab > Inventory Modules > Returns Manager
Once at the Return's Manager you will be able to create a new return or manage existing ones.
Creating a New Return is as easy as clicking the New Return button and entering a name, description and choosing a Vendor. Then you can add products to the Return on the right side of the screen.
Once the item has been added, the quantity selected will be removed from inventory. In the event of a serialized item, the selected serial number(s) will be removed from inventory as well.
After adding your item to the RMA, you can then begin the process of tracking the return.
Return Status Definitions
The following are a description of the various options available:
- Restock - moves back to active/available inventory and resolves the return.
- RMA Requested - changes the status to say it's basically waiting for your vendor to approve the RMA so you can return the item to them. You will then have additional tracking options available:
- RMA Sent - allows you to update the status indicating that the item has been sent back to your vendor. You will have additional status updates to follow your return along the process, either of which will resolve the return. Selecting RMA Repaired will move the item back into active inventory.
- RMA Declined - allows you to indicate that your vendor has declined your RMA request. Selecting this will resolve the return.
- Breakage - this means the item, for whatever reason, needs to be destroyed, inventory lost, broken, etc
- Edit - allows you to modify the return, add items to it, etc
Additionally, when you go through a refund of an invoice that included a product that was maintained/inventoried, it will now prompt you for what you would like to do with the product. Just have it set to Pending by default to put it into the Returns manager:
iFixit - Product Catalogs
A "Product Catalog" in our software is a database of products from a vendor that we have prepared and are able to provide to you to make setting up inventory super simple.
The first one we are launching with is iFixit! They are a great product supplier, lifetime warranties, and a company with a true desire to help repair shops.
iFixit has recently launched wholesale pricing and is gearing up to try to win your business.
Why use a Catalog
When you visit the product catalogs and import some products into your inventory, we automatically setup the vendor (or map to existing with the same name), and we bring in the product SKUs. This makes it so you can easily order from this vendor and always get the exactly correct product.
Another great benefit of using the iFixit catalog is they have really good standardized data around product naming and descriptions, so if you do anything with phones or iPads, this is a great catalog to start with.
How to Start
It couldn't be easier!
Head to Admin -> App Center -> Product Catalogs, click iFixit.
Click the link to go to your "profile edit" page in iFixit and enter the API Auth Token from the software. iFixit requires you to enter a billing address before the API field appears in the settings.
Now you can import all the products, or perform a search and just import the results. (Or, just select a few to import if you want)
How do I add an SKU?
A Stock Keeping Unit (SKU) is an identification number that helps you track your inventory items.
1. Head over to the "Inventory" tab and select "New Item"
*Note: You can also edit an existing item by following the same steps below.
2. Create the product with a name and description
3. Once the product is created, go to the Product detail page of that product and select the button that says " Add SKU". You may have to scroll down a little bit on the product detail page before you see it.
4. Add the desired SKU number and select a vendor. Then select the green "add" button.
You should now see the SKU number under the Vendor SKU's on the Product detail page.
Difference between Parts and Inventory
The Difference between Inventory and Parts
Inventory is one of the most powerful modules in the application. It tracks all sorts of physical/electronic devices, labor, deposits, prepay hours, quantities, when to refill stock, etc. This is the normal equipment you work with everyday, and expect to have in your store or warehouse. When you have low stock on specific inventory, you want to be kept informed so you can re-order. This is why we send out a daily email of all low stock in inventory, so we keep you notified on a daily basis. You use Purchase Orders to resupply low levels of Inventory. Purchase Orders are directly connected with your Inventory and Vendors, making that entire process easy. The Parts module is a completely separate entity.
Parts were intended for a different purpose. This module was created for special orders that you don't normally do, or don't usually keep in stock. Example: Special phone screen for a phone that you don't normally work on, or a special motherboard for a laptop.
There is a Parts tab that can be activated by heading Admin > Tabs Customization > Parts. That way you could use the top navigation bar to quickly get to Parts.
NOTE: The Parts option on the Tabs Customization may be located in a different order for you. This list can be reordered by the account to change the tabs bar order along the top of the screen.
If you head to the Parts Tab, click the New button to start a Part Order.
A new screen will load where you can enter the Order details.
Note: Entering the Cost to the order will automatically calculate the customer price if you have the Markup feature in the Parts Preferences. Head here for more on that.
Part Order - Billing
When you create a Part Order you have two options for billing the customer.
1. You can associate the Part Order to a Ticket and the Part Order charge will be automatically added to the Add/View Charges on the attached ticket when you Save the Part Order.
Note: If you create a Part Order from a Ticket, this field will already be selected.
Here's what the Add/View Charges looks like with a Part Order
2. You can generate an Invoice directly from the Part Order if there is no associated Ticket. After creating the Part Order, click into Edit the Part Order and there will be a New Invoice button. Click the button, and search for your customer and the invoice will be generated.
Note: If there is an Invoice already generated, then a "View Invoice" button will be present.
Here is what the Part Order looks like on the invoice.
How do I delete an inventory item?
Because inventory items may be listed on old invoices, the system is set up to disable them rather than delete them.
You can do that by going to your Inventory Module and clicking disable on the Product overview screen.
If you do choose to delete inventory items, the only way to do that is to export your inventory to CSV, enter TRUE into the "delete" column, and reimport the file.
More Information about bulk updating your inventory via CSV can be found in the Inventory Bulk update section.
Can I add Serial numbers to my inventory?
We do support Serialized Inventory
This is a feature that allows you to track unique serial numbers for individual products, and attached to that serial number will be the date it was purchased, the vendor, the Purchase Order, and then all the history that the product has in our system.
Start by heading to a Product in your Inventory Checking the 'Serialized' checkbox on an item, or make a new item and check Serialized.
Once you have checked the box, there is a button you can click to add serial numbers if you want to manually start out with entering your quantity on hand. This is only available when you first make the product Serialized.
Be sure to hit save at the bottom of the product detail once you added the serial numbers.
Once a serialized product is created, the QTY will be non-editable on the inventory list page;
To view serials scroll down to Product instances, there you will be able to see all serials and their details
If you want to increase the quantity, just make a purchase order.
When you change the purchase order status to "Check-In," these will automatically be added to your inventory, even though the purchase order has not been finalized. You'll then be able to scan in the serial numbers for all the products that arrived. Click Manage Serials to do this.
This will open a MANAGE SERIALS dialog.
At this point you CAN scan fewer than the total ordered, it will only increase the quantity by the number of serials you scan in.
For those items that don't normally have serial numbers, such as RAM sticks and cables, click the Auto-Generate Serial Numbers button. It will fill in each non-blank Serial field with a random 15 digit number. That is, if you have already filled in any of the Serial fields, the button will not overwrite any of them. If you accidentally click the button, you can click Close to cancel all changes, including any you entered yourself.
Click Save changes once you have entered or auto-generated all the serial numbers.
Once these products are in your inventory, add them to a line item just like any other product - but these will require you to put a serial number on the line item before you can proceed.
Notice the quantity says 0 until you select which serial you have sold;
Here it is after we select a serial;
How do I show the cost of my inventory items?
From the Inventory tab, the cost of your inventory will be displayed under Price Cost (what you paid for it) and Retail Cost (what the customer pays for it):
You can edit individually with the edit button, or make bulk changes by exporting the inventory list and reimporting new data.
Can I Bundle Items in RepairShopr?
Yes! We have a full bundles module.
This is especially useful for custom builds or cell phone repairs where you want to track inventory but don't want to show the details of what's include in a line item to a customer.
To start, go to Inventory > Bundles:
Click New Inventory Bundle:
Here, you can name your bundle, add items from your inventory, optimize the price by line item, or make an overall price for the bundle:
- The items included here will be driven off your inventory so it's also possible to include a mix of taxable and non-taxable items. The system will handle calculating things properly for the bundle.
- You can also create a UPC code for the combined bundle.
To add a bundle to an invoice, simply search or scan it in the line items section of the invoice.
You can then click the expand button on the invoice to see what's included.
NB: Please note only the single item will be visible on the invoice for customers and they won't be able to expand the bundle.
Also, to make creating bundles quick and easy (for instance, for screen replacements for many different models of phones), you can use the Clone button when creating bundles in Inventory > Bundles: