What are you looking for?

Get help straight from our team...

Universal Distribution Final Order Cutoff (FOC)

Ordering

Universal Distribution Final Order Cutoff (FOC)

How do you create, edit, and upload a Universal Distribution Final Order Cutoff file?

Last updated on 22 Apr, 2025

Universal Distribution does not offer Initial orders, they only offer Final Order Cutoff files.  We've built a system to allow you to create FOC files using the Manage Comics information.

NOTE - Universal Distribution now accepts CSV imports.

Before you get started, ensure that you have set Universal as your preferred distributor in the Manage Publishers and Product Types settings of Manage Comics.

Generating your FOC files from Universal

Universal FOC's are currently per-publisher (we have asked Universal to create a single FOC file, we will update you on progress of this), on the Universal Distribution site, navigate to comics (1) and then to your distributor of choice (2), click the Download (3) button.

Image

Select "Excel" from the download options

Image

Select "Filtered Data", and save the file.  IMPORTANT, DO NOT OPEN THIS FILE, as Excel will mess it up as often as it doesn't.

Image

Back in Manage Comics, in Ordering > FOC Weekly, select your Distributor/Publisher combo (1), upload the file into Manage Comics (2) by either clicking the Add File, or dragging your XLSX file from where you saved it previously, this will take a while (up to 1 minute in some cases).

Image

Once the file has processed, you can now start to edit your quantities on the FOC.

  • QTY - the Quantity currently on order

  • Subscription QTY - the number of current orders (subscription and pre-orders) for the item

  • New Total QTY - the editable number you can enter.  This should be your shelf + subscription quantity

Image

Scroll to the bottom of the page and select "Download Universal - DC Upload File".

Image

You now have your FOC file for this publisher.  IMPORTANT, DO NOT OPEN THIS FILE UP, Excel will often mess it up.

Back in Universal, upload your file, review your results, repeat for all publishers and enjoy.

Image
Did you find this article helpful?
Previous

Products

Next