Inventory

Advisor

Create questions and answers for the Advisor Tool
Build/Disassemble Products & Parts

Build out of stock products from parts.
Disassemble in stock products for requested out of stock parts.
Split die sets.
Split product sets.
Calibers

Assign calibers directly to target items.
Update caliber nomenclature string variables.
Modify the displaying index sequence arrays for calibers.
Edit caliber lists: Case type, Primer Type, etc
Refresh caliber database attributes.
Categories

Select a product or group of products and assign products to categories. Clean up the categories that have slight differences like "3-Die Set" instead of "3 Die Set".
Search the category structure and view the products within that category and subcategory. Select the categories each product should be assigned to in that category and subcategory.
Update the sort order for the Categories so the default category shown in the Breadcrumbs may be altered.
Clean up the category names and the products inside the category.
Create templates to generate Category Descriptions.
View Category Description Templates.
eBay

On each page load this script scans the OpenCart 3 category tree for book-related categories, resolves descendant category paths, evaluates every `pd_ebay_products` row whose `media` flag is still blank, and writes `media = 'Y'` when the linked OpenCart product sits in a book category path or `media = 'N'` otherwise.
On each page load this script scans the OpenCart 3 category tree for book-related categories, resolves descendant category paths, evaluates every `pd_ebay_products` row whose `media` flag is still blank, and writes `media = 'Y'` when the linked OpenCart product sits in a book category path or `media = 'N'` otherwise.
View prices and profit for items listed on eBay. Update prices in OpenCart to achieve desired profit.
Download the active items from eBay, and update items in OpenCart with missing Item ID's and eBay quantity using the API method.
Download the active items from eBay, and update items in OpenCart with missing Item ID's and eBay quantity using the no API method.
Display products NOT ready to be imported into eBay
Display products READY to be imported into eBay. If none of the products listed need to be disallowed on eBay, go ahead and run "eBay Products Import".
Fix images that are too small and can be fixed by increasing the canvas size of the image.
Fix missing UPC codes.
View eBay Item Specifics.
Verify product names or descriptions do not contain "AR Platform" or "AR". If they are listed, remove them from the FS Reloading store.
Maintains a list of Long terms that can be shortened in titles.
For external stores like eBay and Gunbroker, the product title is run through the program "Long Title Filters" and saved as a Product custom field. This program lists titles too long so they can be manually edited.
Search products by location. Update the active items in eBay or the Active products with the current shelf quantity or location.
etsy

On each page load this script scans the OpenCart 3 category tree for book-related categories, resolves descendant category paths, evaluates every `pd_etsy_products` row whose `media` flag is still blank, and writes `media = 'Y'` when the linked OpenCart product sits in a book category path or `media = 'N'` otherwise.
Featured Products

Select rotation time, sales period, number of products to display, type
Geo Zones

Assign Geo Zones to EVERY product based on their Manufacturer
Override the Geo Zones for Products in SELECTED categories
Create a Geo Zone for selected areas
Manuals, Videos, Rebates

PDF description of products
Rebates for products
Videos describing how to use a product
Manufacturers

Create or update products from a manufacturer or supplier spreadsheet
Mark products that are new to a manufacturer.
Create a list of the different names for a manufacturer and identify the spelling we are using.
Update the table Matching each Manufacturer to a Brands Category. This will create a link in the Manufacturer Carousel.
Grab the product information from our Crow Shooting Supply Invoices.
NewEGG

Check the NewEGG HTML tags have closing tags.
Update the NewEGG Bullets Description.
Product Information

Assign Products & Categories to Store
Create the Custom Weight field
Model, MPN, AltMPN, Name, Prices, Costs, Profits, Profit Margins, Weight, Dimensions, Ebay Weight, Dimensions, Case Weight, Dimensions, Min Reorder, UPC, Color, Material, Condition, Package Quantity, Callibers, Display Order, Information, Supplier, Country, Location, Feed Categories, Categories
Use an existing product as a template to copy, paste, and edit to a disabled products
Find Products without an available box for shipping
Update MSRP with a $ before the amount. If the field is empty, grab the price.
Missing Product Information - Prices, MSRP, Costs, Weights & Shipping Dimensions, UPC codes, Suppliers, shipping methods, small Images, or Manufacturer
Create a template to use to create product descriptions for all products within a category.
Create multiple products from a single description
Look for products pricing errors
Verify and add product suggestions
Restore products that were deleted because they had duplicate product models
Restrict Air Travel for products
Set product reward points for all customer groups
Update Links in Categories, Products, Weblog Categories, and Weblog Articles
Upload and resize Main image and extra images to be 2000x2000 maximum size
Product Parts

Find products with the same RSR Stock Number
Import Lee Precision parts.txt
Import Lee Precision products.txt
Update parts needed for a product
Product Profit

Display Products with a Profit % greater than a defined value, sorted by the products with the highest quantities first.
Product Quantities

Select which of the unsold Products should be added into Clearance
Inventory Turnover with selected Time periods, Suppliers, or Manufacturers
Search Google products by location. Update the category Paths, Small Images.
Update quantity on shelf
View the product quantity logs for a given product
Read-only report of `pd_pick_table` allocations still attached to closed OpenCart orders.
Operational batch delete of stale or duplicate `pd_pick_table` rows.
Purchase Orders

Create and edit a purchase order
Create a PDF for a purchase order and mark it sent when it has been emailed - Set the estimated arrival date for the product
Delete a purchase order that was not used
Edit product costs from suppliers that are not the default manufacturer
Match suppliers with the products of manufacturers they sell
Merge two purchase orders into one purchase order
Display the Purchase Orders that are outstanding.
Display Purchase orders which most of the products have been received, but we are still waiting for some.
Display products on Purchase orders which have sold.
Display all products on all Purchase orders which have sold.
Check the products into inventory when the shipment arrives
Update the estimated arrival date and a message for purchase orders
The PreorderQtySpider.php will update the Expected Restock Date only if the Restock Message is empty
Updates Office information for each store to be included in the top of each Purchase Order.
Updates Supplier information for each Purchase Order.
Special Offers

Choose which products should be excluded from Special Offers.
Select the number of products for each manufacturer in a store
Resolve the products that are assigned to the selected store, but the manufacturers are not assigned to the store.
Builds a ranked shortlist of active, in-stock catalog products (excluding discontinued `-Disc-` models) and lets the operator assign a percent-of-profit cut.
Builds an HTML newsletter to be copied and pasted in to the shippingeasy.com newletter tool.
Special Sale (Holidays)

Select products not sold in the last six months and mark the sale price at cost.
Select products not sold in the last six months and mark the sale price at cost.
Choose which products should be excluded from Special Sales.
Create special one-time sale of products
Warehouse

Displays a report of the OpenCart custom fields. This program is a popup helper program.
Display location labels
Create location label names
Create location labels
Warnings

Update product restrictions
Update product warnings