+1-757-461-3022 x124

Library

Primary tabs

Do I need xTuple Connect in order to send emails?

xTuple Connect is required when you send email notifications using the xTuple Desktop. 

Was this Helpful?
up
236 users have voted.

What are email profiles?

Email profiles are templates used to format the presentation of outgoing email messages. The profiles can be configured to use contact names, email addresses, and other CRM information stored in the database—thereby increasing automation and reducing the opportunity for errors. Using email profiles, you can standardize your communications with your customers and vendors.

Was this Helpful?
up
235 users have voted.

How is the xTupleCommerce product catalog structured in the xTuple ERP database?

The product catalog is a collection of categories which items may be grouped into. Think of it as being like the physical catalog department stores might use. The following terms are used:

  • Parent group: The parent group is typically a very generalized group of items. For example, if you had a shoe store, the parent groups might be men’s shoes, women’s shoes, kids’ shoes, etc.
  • Item groups: Item groups are more specific groups within the parent group. If the parent group is women’s shoes, the item groups may consist of sandals, sneakers, pumps, boots, etc.
  • Member items: Member items are the individual items within the item group. If we selected the sneakers item group, the member item would be the exact red sneaker that a customer may add to their cart for purchase. 
Was this Helpful?
up
232 users have voted.

What size should my product related images be for them to fit correctly on my xTupleCommerce website?

To ensure that your product-related images appear properly on the xTupleCommerce website, we suggest using the following sizes:

Item Group Image Sizes

  • Item group image - 160px wide x 90px tall

Product Image Sizes

  • Horizontal Product Image - 1000 x whatever is needed
  • Vertical Image - whatever is needed x 1000
  • Maximum Size - 1000 x 1000
  • Minimum Size - 360 x 360

More information about Product Images

The product images are added to the item master in the ERP. The images are automatically resized for the various places they are used which include:

  • All Products Page (thumbnails)
  • Product Details - Main Image
  • Product Details - Thumbnails
  • Product Details - Magnification
  • Suggested Items (thumbnails)

To optimize the user's experience we suggest using large images (maximum of 1000px x 1000px) then letting the system scale them down.

All Products Page - The space that is available for images on the All Products page is 260 x 135. Images that are larger will be sized down to fit in this area and stay in proportion to the original size.

Product Details Page - The space that is available for images is 360 x 360 however, larger images can be used. If the Product image is larger than 360 x 360, when the user rolls over the image with their cursor, a “Magnifying Glass” will zoom into the area that the cursor is over.

Recommended Product Image Size - The best product images are in ratio to 237x125. This size is a perfect fit for the Products page. If you increase this to be a perfect fit for the Product Details page, the size would be 360 x 190. Images in ratio to these sizes will render the best on the website. The ideal Product Image size is 1000 x 528, but we understand not all product images will fit into that space in an optimal fashion.

More image information

To learn more about Image Sizes for xTupleCommerce, see this xTupleU article

Was this Helpful?
up
230 users have voted.

Our xTupleCommerce website is down. What do we do?

If you are hosting your website on your own web server, we suggest you try rebooting your server. If your website is being hosted on the xTuple cloud, please report an incident and we will reboot it for you.

Was this Helpful?
up
226 users have voted.

When are expense categories used?

Expense categories are used to automate the accounting for non-inventory transactions. The following transaction types use expense categories: non-inventory purchase order line items; miscellaneous vouchers; miscellaneous payables checks; and expense transactions.

Was this Helpful?
up
226 users have voted.

What is the goal of project accounting?

The Project Accounting add-on package for xTuple is a solution especially designed for professional services companies, non-profit groups who need fund accounting and manufacturers or distributors with advanced project accounting requirements. At the heart of Project Accounting is the concept of the "virtual" General Ledger (G/L) Account. With Project Accounting, virtual G/L Accounts are built dynamically or "on-the-fly" using a combination of existing G/L Account Numbers and the linked Project Name. Transactions flowing from Project-related Sales Orders, Purchase Orders and Work Orders are generally supported by Project Accounting.

Was this Helpful?
up
225 users have voted.

Does Connect support SSL or TLS?

Yes, beginning with xTuple Connect version 3.8, support is available for SSL and TLS encryption for email sent over SMTP.

Was this Helpful?
up
224 users have voted.

How do I import data into xTuple?

There are two methods for importing data into the database of xTuple ERP.

  • CSVimp
    First, xTuple offers a free application called CSVimp that is designed to migrate Comma Separated Value (CSV) files into the database for the xTuple Applications (The same tool works for PostBooks®, Standard and Manufacturing Editions). You can download CSVimp from our SourceForge project site. And detailed instructions for using CSVimp are available in our documents section.
  • xTuple API
    The second method is to use the API. The goal of the xTuple Application Programmer Interface (API) is to make migrating data directly into the database much safer and easier than it is going directly into the regular table structure. Our appoach is to allow users to create, access, and update xTuple documents using a special database schema that closely mirrors the graphical user interface (GUI). You can read more about using the API to import data into xTuple ERP in the docs section.
Was this Helpful?
up
224 users have voted.

I updated information in the ERP, but it’s not showing up on my xTupleCommerce website. What could be happening?

Some information may not show up on the xTupleCommerce website immediately. Instead, it stays in the cache. Think of the cache as a net that holds on to some of the changes.

To manually flush the cache (release the net of changes), log in to your xTupleCommerce website. Then navigate to Admin > Icon > Flush all Cache and select to flush all the cache.

Note-If after flushing the cache the formatting of the site looks like it has changed, refresh the page and it should go back to normal. 

 

Was this Helpful?
up
223 users have voted.

Do you have basic project management information?

The topic of project basics is covered in some detail in the manual Managing Projects with xTuple. The book can be read online for free or purchased for download through the xTuple MarketPlace.

Was this Helpful?
up
222 users have voted.

How can I learn more about job costing?

The topic of job costing is covered in some detail in the manual Managing Projects with xTuple. The book can be read online for free or purchased for download through the xTuple MarketPlace.

Was this Helpful?
up
222 users have voted.

Are the advanced characteristic options required?

The advanced characteristics options—available only to text type characteristics—are not required. You may use text type characteristics without using the advanced options. The two advanced options are input mask and validator. An input mask creates a template to guide users as they enter values for a characteristic. It is a form of light data validation. For example, if you specify the input mask 00/00/0000, then users will be presented with the following template when they are entering values for the characteristic : "__/__/____". In this case, users will simply have to fill in the blanks between the separators. A validator is used to strictly enforce the format of data users can enter in a field. If you specify a validator for a characteristic, then users will have to conform to the format when entering values for the characteristic. Values which do not conform will not be accepted.

Was this Helpful?
up
220 users have voted.

What is XTN?

XTN (xTuple Network) is a commercial business continuity service, featuring off-site backup and xTuple ERP version upgrades. Please follow this link to learn more about xTuple's XTN service.

Was this Helpful?
up
220 users have voted.

Can I manage my item images in the xTupleCommerce website?

Your xTupleCommerce site has the capability of hosting images, PDFs, documents and other media. Once your site is live you can associate these files with Items and Item Groups in the ERP. For instance, you can associate product images with Items in the ERP. Or you can associate Marketing PDFs with Items in the ERP. These images and PDFs will be displayed with the products on the xTupleCommerce site.

If your site is still in the development or testing phases (aka, you are still going to a stage.domain.xtuple.net URL to view your site), we encourage you to use a service such as Cloudinary to host your images and determine URLs.

However, if your xTupleCommerce website has gone live, you can begin using the site to host files and create the URLs needed for the document in the ERP. 

Uploading the files to your xTupleCommerce site :

  1. Go to your xTupleCommerce website and login as a manager or editor. 
  2. Navigate Admin > Content > Files.
  3. Click ADD FILE
  4. Select and upload the image. Typically files must be less than 8MB. 
  5. Click NEXT
  6. Leave the radio button selected for public local files and click NEXT.
  7. Update and fill in the fields for name and file name. The name will show up in the URL path of the image. 
  8. Click SAVE. 
  9. Highlight the path of the image-most recently added files are on the top of the list-and copy.

Associate files with Items or Item Groups in the ERP

  1. Login to your ERP.
  2. Open an Item or Item Group
  3. Go to the documents tab
  4. Click Attach
  5. Choose Web Site from the drop down
  6. Give the file a name in the Name field
  7. Paste the URL into the URL Field
  8. The URL should include your website domain followed by the path that you copied.  
    Example: https://www.yourwebsite.com/files/public/content/media/image.jpg
  9. Click Save 
  10. Save and close the Item and Item Group

Check your work

Navigate to the Item or Item Group where the file should appear on the website

The file should appear. If the file does not appear, you may need to flush the cache on the website.

Was this Helpful?
up
219 users have voted.

How do transfer orders differ from inter-site transfers?

Transfer orders are distinct from inter-site transfers in three primary ways. First, transfer orders allow you to move multiple items all at once between sites—instead of just one item at a time. Second, transfer orders always involve an intermediate transit site, for tracking inventory while it is "in transit." And third, there are reports (i.e., paperwork) associated with transfer orders.

Was this Helpful?
up
219 users have voted.

Why can't I ship my transfer order?

If you are trying to ship a transfer order but it doesn't appear in the list of orders to be shipped, there's a good chance the transfer order has not been released yet. Transfer orders must be open/released before they can be shipped. To release a transfer order, change its status from unreleased to open.

Was this Helpful?
up
218 users have voted.

Can I add PDFs to an item and have them show up on my xTupleCommerce website?

Yes, you can add documents, such as PDFs, to individual items in the same way that you would add images linked to items. Like item images, the PDFs need to be stored on a separate web server, with a unique URL for each PDF. However, the ERP should contain cross references to these PDFs, via their URL.

To enter URLs for PDFs in the ERP, go to the item master for the item in question and follow these steps:

  1. Select the documents tab
  2. Choose the ATTACH button
  3. Next to the "related to" option, choose the "website" option from the list
  4. Enter the URL for the PDF
  5. Specify a name to identify it

The PDF will show up on the product page as a link for the user to view and download.

Was this Helpful?
up
216 users have voted.

What API keys and fields are required to use FedEx with xTupleCommerce?

If you want to include FedEx in the list of shipping options for your xTupleCommerce customers, you'll need to acquire API keys from FedEx, for both your production and development environments. Once you have the information and have added the keys to the ERP, the keys will need to be added to the xTupleCommerce website.

Here is an outline of the fields you need for both the production and development keys: 

Production Keys

  • Account Username
  • Account Password
  • Authentication Key
  • Meter Number
  • Account Number
  • Production API Password
  • Production URL

Development Keys

  • Account Username
  • Account Password
  • Test Key
  • Test Key Password
  • Test Account Number
  • Test Meter Number
  • Test URL
Was this Helpful?
up
216 users have voted.

Can I use abbreviations for state names?

Yes, you may abbreviate state names. However, before manually adding a state (or province) you should check whether the state already exists in the database. (Hint: If you enter the country first, the corresponding states, if available, will appear.) For example, the default list of states for the United States uses the standard two-letter abbreviations. New York appears as NY and Virginia appears as VA in the list of U.S. states.

Was this Helpful?
up
215 users have voted.

How do I drill down into inventory history?

The advanced search panel gives you the most control when trying to locate specific records or groups of records in inventory history. Click on the advanced search button in the main menu to open the advanced search panel. Using advanced search, you can specify multiple different parameters—making it possible to drill down and reach the specific records you are looking for.

Was this Helpful?
up
214 users have voted.

How do shipment numbers get generated?

Shipment numbers are generated as soon as you issue stock to shipping for an order. The shipment number is pulled from the shipping configuration panel. During configuration, you define the initial shipment number—and then every shipment automatically increments the base shipping number by one. For example, if your starting shipment number is 60001, the second will be 60002, the third 60003, etc.

Was this Helpful?
up
214 users have voted.

How do we boot a user from the database?

In order to forcefully disconnect a user from the database, you have to find the Process ID (pid) for the backend connection of that user. Each user connection to the database spawns a backend process for their connection. Once you know the pid for the process, you can kill the process. On unix the command would be "kill [pid]" while other OSes may have different ways to kill a process. In order to find the pid you can look at the pg_stat_activity table and the column procid should contain the number you need.

Was this Helpful?
up
214 users have voted.

What are the job cost recognition options?

The job cost recognition options establish the default costing behavior when creating work orders for average cost or job items. These defaults can be overridden at the item site level or at the level of specific work orders you create. If the to date option is specified, all of the WIP costs accumulated to date will be charged to the cost of sales when the item is shipped. If the proportional option is specified, a value up to the proportional value of the total quantity shipped will be charged to the cost of sales when the item is shipped. For an example of the proportional method, assume 3 items are to be shipped on a job work order and all the material has been issued—and if only 1 of the 3 is shipped—then 1/3 of the value charged to WIP at that point will be charged to the cost of sales.

Was this Helpful?
up
214 users have voted.

What is a characteristic role?

Characteristic roles define where characteristics can be used. For example, if you want a characteristic to be associated with contact records, you would select the contact role. Item characteristics would require the item role. And so on. Individual characteristics may be associated with multiple roles. The same characteristic might apply to contacts and addresses and opportunities. If you are having trouble finding a characteristic to associate, it's likely the characteristic role isn't defined properly.

Was this Helpful?
up
214 users have voted.