Description
Powerful and advanced WooCommerce bulk edit plugin to manage your store from one place in a user-friendly, Excel-like sheet editor.
Smart Manager is a lifesaver. Anyone starting a new store or migrating to a new line (perhaps seasonal shifts) should consider this mandatory in their toolbox.
– Envoymatt
Smart Manager is a single-screen, excel-like interface to browse and manage these dashboards – ** products (all types), orders, blog posts, and coupons**.
Select a dashboard and start making edits without leaving the spreadsheet. Speed up the way you create content and manage your store.
Manage Products, Orders, Coupons, Get endless powerful features with this plugin
? Bulk edit all WooCommerce product types including custom ones – simple, variable, product variations, subscriptions, bundles, grouped, and more.
? Smart WooCommerce bulk product editor – Bulk edit SKUs, weight, quantity, backorders, stock status, tax status, shipping class, product title, gallery images, and all the important stock management-related fields.
? WooCommerce bulk edit attributes and categories – bulk assign/remove categories and attributes to/from products, and also manage them effortlessly.
? WooCommerce bulk edit price – change regular price and sale price.
? Bulk edit WooCommerce orders, coupons, blog posts, users (customers), subscriptions, product addons… any WordPress post type, custom taxonomies, and custom fields.
? Do an advanced search and make bulk edits.
? Perform operations like append, prepend, increase, decrease, search and replace, etc. in bulk.
? Schedule bulk edit – set a specific date to perform your bulk edit task. For example, increase all product prices tomorrow by 15%.
? Undo your bulk edit operations if required.
? Compatible with WooCommerce High Performance Order Storage (HPOS)
Power-packed lite (free) version:
- Inline edits – Up to three direct edits simultaneously without saving the changes.
- Live preview and infinite scrolling for smoother navigation.
- Zero edit restrictions on the post-type fields available.
— Products – increase/decrease the sale price and regular price, manage backorders and SKUs, change product descriptions, categories, attributes, tags, tax class, tax status, etc. WooCommerce stock management can’t get simpler than this.
— Orders – change status, billing details, shipping details, currency, etc.
— Coupons – modify coupon usage, amount, type, expiry date, etc.
— Posts – title, image, update post status from draft to publish, etc. - Edit post types using search filters, date filters, and column filters.
- Stock log – see the stock history for each product and identify how quickly it is moving.
- Edit product variations for variable products after clicking on the “Show Variations” button.
- Add new products, orders, coupons, and posts directly using the spreadsheet.
- Import products CSV
- Export CSV of stock-related data columns for products.
- Delete/Move to trash single or multiple products, orders, coupons, and posts.
- Search using keywords, categories, attributes, or any other field.
- Advanced Search with AND condition, search operators (<,>,=,<=, >=, is, contains, etc.) and drop-down filters. Makes it easy to filter inventory by type, category, – backorders, manage stock, stock status, order status, coupon type, post status, and a lot more…
Example – Search for SKU is WC09 and price >= $600. - Admin Columns – Show/hide data columns for better usability. Sort data to personalize the dashboard view. For example, sort sale prices in ascending or descending order.
- Reset the order of the admin columns to the default view.
- Email notifications are sent to customers automatically when the order status changes.
- Transactional notes are also automatically added to the order when the status changes.
- Sticky header to always stay in control when scrolling through thousands of records.
- Image preview for image type fields in the grid for easier identification of your WooCommerce inventory.
- Distraction-free mode when performing store operations.
18300+ users love the Smart Manager WooCommerce bulk editor…
Embrace the power of next-generation WooCommerce store management. Smart Manager is an indispensable tool for all WordPress users.
Smart Manager makes our day way more productive. We now can change our stock in just 2 clicks instead of hours of work. Also, the support is really quick and helpful!
– Jasper Vandiemen‘An Essential Plugin for WooCommerce – Smart Manager Exceeds All Expectations!’
I wholeheartedly recommend Smart Manager. It is an essential plugin for any WooCommerce user looking to streamline their product management and increase efficiency. With its wide range of features, seamless integration, and outstanding performance, Smart Manager has exceeded my expectations and become an indispensable tool in my online store. Give it a try and experience the benefits of this amazing plugin for yourself!
– Mio Creativ
Why should you choose Smart Manager WooCommerce bulk editor?
Powerful features – Smart Manager is jam-packed with powerful features both in the Lite (free) and the Pro (paid) versions.
Zero coding chaos – Update your data within seconds with just a few clicks. No learning curve or tech skills needed.
Efficiency – Save hours every week by ditching mundane tasks and embracing advanced WooCommerce bulk editing bliss.
Error-busting hero – Say goodbye to calculation errors and inconsistencies with lightning-fast batch processing.
Data delight – Export data with ease, keeping your information safe and sound.
Happy customers, happy life – Smooth WooCommerce inventory management, WooCommerce orders management, and efficient operations mean happy customers and a thriving business.
TL;DR: With Smart Manager Lite, effortlessly manage your e-commerce store by performing inline edits on products, orders, coupons, and posts. Use advanced search filters to quickly find and edit posts with specific keywords, manage stock levels, and track product performance. Bulk edit prices, update SKUs, or change order statuses with ease. Add new products or orders directly through the spreadsheet interface and monitor store activities effortlessly.
I’m very happy using the free version of the plugin on my WooCommerce site. No issue with a lot of plugins I have active on my site.
The best is the support: 6 stars I would give them. Keep in mind that I’m talking about the free version and from the first contact they have been very kind and fast. Sure I recommend it!
– FreelanceJose
Smart Manager Pro features:
Stay ahead of your competitors with Smart Manager Pro.
- WooCommerce advanced bulk edit / batch update / mass update any post type records – products, variations, orders, coupons, subscriptions, bookings, media, users/customers, courses, events, product add-ons, advanced custom fields, custom meta fields, etc.
- Inline edit (direct edit) records from the grid – Update inventory, modify order status, change the coupon expiry date, add post images, etc.
- Bulk edit 100000+ records for any post type within minutes. Smart Manager has successfully tested these numbers.
- Update single/multiple fields for a few or all records at once…without errors!
- Quick WooCommerce stock management – change prices, increase inventory levels, change product categories, attributes, or any other fields, all in bulk quickly.
- Bulk edit order statuses including custom order statuses, search for orders using advanced filters, export orders to CSV, and more…WooCommerce order management made easy.
- Copy any field from any record using Bulk edit / Batch update.
- Copy value from any other field for any record.
- Copy the attributes of a specific product and bulk assign the same to multiple products.
- Filter any post type & perform bulk edit operations on them.
- Utilize your time for other business tasks while the Bulk edit / Batch update runs in the background.
- Inline update ‘Product Gallery Images, Featured Image’ using the media library.
- Undo inline edit and bulk edit changes (Tasks) you made. Name your tasks and revert the changes at once. It can be a single task or multiple tasks.
- Delete all products permanently or move them to trash – based on filters, categories, and attributes. Delete featured images and media library images directly from the grid.
- Delete records for orders, coupons, and any post type in bulk. You can do it using our search filters too.
- Delete media when any post-type record is deleted, provided the media is linked with that post-type record only.
- Duplicate single, multiple, or all records for any post type.
- Perform an advanced search using multiple AND, multiple OR, multiple AND + OR conditions to get very specific results and then make inline edits or bulk edits.
A massive time saver…flawless export!
We have over 6000 individual lines on our site and this has saved us huge amounts of time.
Bulk edit works flawlessly, which is a massive time saver. If you need to change all of your prices on the entire site by a % or value, you can with a couple of clicks! We updated the Tax > class on all products in less than 3 minutes. The CSV export tool actually works unlike some I have tried, with all 6000 odd lines neatly exported in one attempt. No missing or corrupt data.
– Kevin Goodchild, Obsolete Electronic Components
- Create Excel-like custom views / segmented views / column sets, i.e. view only the data you want. Enable / disable data columns, make edits, apply filters, and save. – Supports all post types and custom taxonomies.
- Predefined custom views – Product Stock & Product Price List
- Advanced Export CSV for all post types and custom taxonomies – all or filtered data using date filters, search filters, or column filters. Use it for better inventory management, reporting, sales, designing your marketing campaigns, migration to a new store, etc.
- Rename the admin columns title at your convenience. For example, change Stock to Quantity.
- Add your own logo to packing slips.
- Print PDF invoices for orders in bulk.
- Know the lifetime value (LTV) of all your customers along with their total purchases to date and last order details.
- Manage WordPress user roles – change user role, change password, etc.
- Give dashboard-specific access to non-admin users including any custom user role. You can even give dashboard specific access to any specific user email.
- Manage and edit WordPress custom taxonomies.
I would happily pay five times for this product!
What really sold me on this was Bulk Edit. My assistant does not have to do any complex math now (earlier, I always feared she would make a mistake)! With Smart Manager, she has more free time at hand, hence I asked her to set up autoresponder emails for our customers. The response was phenomenal. Our repeat sales were up by 19.5%.
– Jeff Smith
- Import orders, coupons, and any other post type (coming soon).
- Manage, view, filter, and edit custom fields of top WooCommerce & WordPress plugins. Smart Manager is compatible with these plugins. It automatically recognizes all custom fields added by other plugins.
— Advanced Custom Fields (ACF)
— WooCommerce Subscriptions
— Affiliate For WooCommerce
— WooCommerce Smart Coupons
— WooCommerce Memberships
— WooCommerce Bookings
— WooCommerce Product Add-Ons
— WooCommerce Cost of Goods
— Min/Max Quantities
— Min and Max Quantity for WooCommerce
— Woocommerce Minimum and Maximum Quantity
— Customer Email Verification
— Yoast SEO
— WordPress SEO Plugin – Rank Math
— Germanized for WooCommerce
— LifterLMS
— TutorLMS
— ShopEngine
— WooCommerce Dropshipping
— WooCommerce Product Vendors
— Orderable
— GiveWP
— File Uploads Addon for WooCommerce - And all other features of the Smart Manager Lite version…
TL;DR: With Smart Manager, search for all expired subscriptions and delete them, bulk edit bookings made between a date range, inline edit a membership based on search, search for all posts having the same keyword and make an edit, modify the cost of goods in bulk, manage courses, and a lot more…
Easily manage suppliers, vendors, and warehouses, and stay in control of your WooCommerce inventory management.
Get priority support from plugin developers and receive plugin updates till your license period.
Try all these features in the Smart Manager Pro Live Demo
There is no comparable solution
Smart Manager Pro is an absolutely efficient tool for handling large datasets, especially when you need to delete them from the SQL database.
Seamlessly integrated with WooCommerce, it’s always up-to-date. I particularly love its feature of permanently deleting images – it automatically removes them from the server, SQL database, and library.
Its advanced search methods make it a powerful management plugin. Additionally, it boasts super fast support that’s truly committed to assisting and resolving issues. Highly recommended for effective management tasks.
– FelixThis software is indispensable!
It is possible to operate in bulk on anything: categories, attributes, tags, moving products from one category to another…
We had a problem and support walked us through the resolution, even creating a software update to test the resolution.
In 20 years of working on the web, I have never found an assistance that does not abandon you and does not attribute the problem to other causes.
– Lolopo
Click here to know the difference between Lite & Pro versions.
It’s your smart WordPress bulk edit plugin that won’t fail you!
The plugin is also GDPR-ready – it doesn’t collect personal data.
How to use Smart Manager?
- Bulk edit attributes
- Bulk edit WordPress posts and pages
- Advanced products export to CSV
- Advanced orders export to CSV
- Export customers or users
- Delete all products
- Find products, orders, subscriptions by SKU
- Set product featured images
- Create Excel-like custom views / Column Sets
- Manage WordPress admin columns
- Manage backorders in bulk
- Bulk edit sale price
- Bulk assign or remove product categories and sub-categories
View more…
Smart Manager Pro Demo, Documentation, and other links…
- Smart Manager Detailed Documentation
- Compatible with latest versions of both WooCommerce and WP e-Commerce
- Available Translations: Dutch, Brazilian Portuguese, French, Romanian, Italian
- Want to add a new language to Smart Manager? Contribute via translate.www.remarpro.com.
- Questions? Contact us
StoreApps’ other Pro plugins
- Offermative – Automated discount, related product recommendations, upsells for WooCommerce.
- WooCommerce Bulk Variations Manager – Create & set prices for thousands of product variations at once.
- Smart Offers For WooCommerce – Targeted WooCommerce one-click upsells, BOGO, order bumps and Buy Now buttons for direct checkout.
- Email Customizer for WooCommerce – Customize default WooCommerce transactional emails to match your brand. Edit text, colors and other elements in a live preview.
- WooCommerce Name Your Price Plugin – Create a pay what you want or a donation-based pricing system.
- Frequently Bought Together For WooCommerce – Show users related products or recommendations to the product they are already viewing.
- Express Login For WordPress – Create secure, auto-login links for WordPress and WooCommerce without the need for a username and password.
View out all our WooCommerce plugins
Our other free plugins
- Icegram Express – Email Subscribers & Newsletters
- Icegram Engage – Popups, welcome bar, opt-ins and lead …
Screenshots
Smart Manager Dashboard (some functionality available only in Pro version)
Bulk edit / Batch update (only in Pro version)
Installation
- Unzip and upload contents of the plugin to your
/wp-content/plugins/directory - Activate the plugin through the ‘Plugins’ menu in WordPress
- Click on ‘Smart Manager’ option within WordPress admin sidebar menu
FAQ
-
Can I export data in CSV?
-
Yes, you can but export feature is available in Pro version.
-
Can I import data ?
-
Smart Manager does not currently support import.
-
Which browser to choose for best performance?
-
Smart Manager works best in Chrome, Firefox. Currently it is not compatible with IE.
-
What do I get in this Lite version?
-
Spreadsheet like view of products, orders and posts. Search and navigation, limited inline editing, ability to delete multiple items at once, a quick edit link to WooCommerce / WP e-Commerce editing screen.
-
What do I get in the Pro?
-
Pro version has unlimited managing of product variations, full inline editing right within the spreadsheet view and a powerful Batch Update screen where you can apply multiple smart update actions to selected / all items. You can also add / duplicate products or the entire store. For Customers, you can see total sales for each customer and their last order details. You can also export data into CSV and print orders / packing slips. And not just WooCommerce, you can manage any WordPress custom post type.
It also gives the warm feeling of supporting further development of the plugin.
Reviews
Contributors & Developers
“WooCommerce Advanced Bulk Edit Products, Orders, Coupons, Any WordPress Post Type – Smart Manager” is open source software. The following people have contributed to this plugin.
Contributors
“WooCommerce Advanced Bulk Edit Products, Orders, Coupons, Any WordPress Post Type – Smart Manager” has been translated into 1 locale. Thank you to the translators for their contributions.
Interested in development?
Browse the code, check out the SVN repository, or subscribe to the development log by RSS.
Changelog
8.49.0 (15.11.2024)
- New: WordPress 6.7 compatible
- New: WooCommerce 9.4.1 compatible
- New: WooCommerce Product ‘Slug’ column in WooCommerce Import CSV suite
- Fix: Fetching hidden meta fields in the grid impacting dashboard load speed
- Fix: Broken user interface due to ‘select2’ library conflict with other plugins
- Fix: Column header height updated with update in row height setting
- Fix: Image in the ‘Featured Image’ column not respecting the row height setting
- Fix: Internationalization related warnings on WordPress v6.7
- Update: 10x speed improvement for Bulk Edit, Move to Trash & Delete Permanently functionalities (Pro)
- Update: UI/UX for combo boxes
- Update: POT file
8.48.0 (01.10.2024)
- New: WooCommerce 9.3.3 compatible
- Fix: ‘Post Date’ column not saving when adding the record using Add Row functionality and updating using inline edit functionality
- Fix: ‘Post Date’ column not saving when updating using Bulk Edit functionality (Pro)
- Update: UI/UX for Advanced Search functionality
- Update: Automatically resize the display of ‘Featured Image’ in the WooCommerce Products dashboard to match the ‘Grid Row Height’ global setting
- Update: POT file
8.47.0 (12.09.2024)
- New: WordPress 6.6.2 compatible
- New: WooCommerce 9.2.3 compatible
- Fix: Clicking on column headers displays modal dialogs in some cases
- Fix: Incorrect last accessed dashboard on page refresh
- Update: UI/UX for ‘Public’ view settings in Custom Views (Pro)
- Update: POT file
8.46.1 (26.08.2024)
- Fix: WordPress database error message when updating WooCommerce Products using inline edit functionality in WooCommerce v9.2.0+
- Update: POT file
8.46.0 (26.08.2024)
- New: WooCommerce 9.2.2 compatible
- Fix: Broken access control vulnerability [Thanks to Patchstack team]
- Fix: Height for longtext data in the grid cells broken after last update
- Update: POT file
8.45.0 (08.08.2024)
- Fix: Height for longtext data in the grid cells not respecting the ‘Grid row height’ global setting
- Fix: ‘Order Subtotal’ column not showing the correct value on WooCommerce Orders dashboard
- Fix: ‘Order Subtotal’ column not showing the correct value on WooCommerce Subscriptions dashboard (Pro)
- Fix: Date picker for the ‘Schedule Later’ option allowing selection of past dates (Pro)
- Update: POT file
8.44.0 (02.08.2024)
- New: WooCommerce 9.1.4 compatible
- Fix: ‘copy from field’ operator not working when the field data type is numeric in the Bulk Edit functionality (Pro)
- Update: Persist search conditions when switching from post type/taxonomy dashboard to task dashboard (Pro)
- Update: POT file
8.43.0 (26.07.2024)
- New: WordPress 6.6.1 compatible
- New: WooCommerce 9.1.2 compatible
- New: Manage ‘Shipping Method Title’ column on WooCommerce Orders dashboard
- New: Manage ‘Shipping Method Title’ column on WooCommerce Subscriptions dashboard (Pro)
- New: Manage ‘Note For Customer’ column on WooCommerce Orders dashboard (Pro)
- Update: Show warning modal for unsaved changes in inline edit functionality
- Update: POT file
8.42.0 (09.07.2024)
- New: WordPress 6.5.5 compatible
- New: WooCommerce 9.0.2 compatible
- Fix: Simple search functionality not working for ‘Shipping Method’ column in both HPOS and non-HPOS stores on WooCommerce Orders dashboard
- Fix: Simple search functionality not working for ‘Shipping Method’ column in both HPOS and non-HPOS stores on WooCommerce Subscriptions dashboard (Pro)
- Fix: Field values not loading when switching to ‘copy from’ operator in Bulk Edit panel for non-HPOS stores on WooCommerce Orders and Subscriptions dashboards (Pro)
- Update: POT file
8.41.0 (21.06.2024)
- New: WooCommerce 9.0.1 compatible
- New: Provision to edit ‘Shipping Method’ column on WooCommerce Orders dashboard
- New: Provision to edit ‘Shipping Method’ column on WooCommerce Subscriptions dashboard (Pro)
- Fix: Inline edit functionality not working for ‘Order Shipping/Shipping Total Amount’ and ‘Shipping Method’ columns on WooCommerce Orders dashboard in both HPOS and non-HPOS stores
- Fix: Bulk Edit functionality not working for ‘Order Shipping/Shipping Total Amount’ and ‘Shipping Method’ columns on WooCommerce Orders dashboard in both HPOS and non-HPOS stores (Pro)
- Fix: Inline edit and Bulk Edit functionalities not working for ‘Order Shipping/Shipping Total Amount’ and ‘Shipping Method’ columns on WooCommerce Subscriptions dashboard in both HPOS and non-HPOS stores (Pro)
- Fix: Advanced search functionality not working for ‘Shipping Method’ column on WooCommerce Orders and Subscriptions dashboards in both HPOS and non-HPOS stores (Pro)
- Update: Pricing page related changes
- Update: POT file
8.40.0 (14.06.2024)
- New: WordPress 6.5.4 compatible
- New: WooCommerce 8.9.3 compatible
- Fix: ‘Edit’ column not fetched on WooCommerce Orders dashboard in HPOS stores
- Fix: ‘Edit’ column not fetched on WooCommerce Subscriptions dashboard in HPOS stores (Pro)
- Update: Pricing page related changes
- Update: POT file
8.39.0 (01.06.2024)
- New: WooCommerce 8.9.1 compatible
- Fix: PHP warnings occur and no content is displayed on the ‘Go Pro’ page if WooCommerce is not activated
- Fix: Array to string conversion PHP notice when loading WooCommerce Products dashboard (Pro)
- Fix: Settings button not redirecting properly on ‘Docs & Support’ page (Pro)
- Update: ‘Author’ column now displays name and email address on WooCommerce Product Stock Log or any tasks dashboard
- Update: Administrators now have the capability to manage and undo tasks performed by any user directly from the WooCommerce Product Stock Log or tasks dashboard
- Update: POT file
8.38.0 (10.05.2024)
- New: WordPress 6.5.3 compatible
- New: WooCommerce 8.8.3 compatible
- Fix: Product type updated incorrectly, when updating ‘Backorders’ column on WooCommerce Products dashboard using inline edit functionality
- Fix: PHP warning when loading WooCommerce Products dashboard
- Fix: Record values not updated in some cases when using Bulk Edit functionality in background (Pro)
- Update: POT file
8.37.0 (18.04.2024)
- New: WordPress 6.5.2 compatible
- New: WooCommerce 8.8.2 compatible
- New: Compatibility with Legal Pages
- Fix: PHP warning when loading WooCommerce Products dashboard
- Fix: Using ‘increase by/decrease by’ Bulk Edit operators setting value to ‘0’ for WooCommerce Products ‘Regular price’ & ‘Sale price’ fields having empty values (Pro)
- Fix: Using ‘increase by/decrease by’ Bulk Edit operators setting value to ‘0’ for any numeric fields having empty values (Pro)
- Update: Replace ‘woo.com’ links with ‘woocommerce.com’
- Update: POT file
8.36.0 (05.04.2024)
- New: WordPress 6.5 compatible
- Fix: ‘Featured’ column not detected in ‘Column Manager’ on WooCommerce Products dashboard
- Fix: PHP 8.1.27 Uncaught TypeError: Cannot access offset of type string on string when clicking on ‘Load More Products’ button on WooCommerce Products dashboard
- Fix: Advanced Search not filtering null value for date fields on WooCommerce Subscriptions dashboard (Pro)
- Fix: PHP warning when fetching all accessible views for current user (Pro)
- Update: POT file
8.35.0 (22.03.2024)
- New: WooCommerce 8.7.0 compatible
- Fix: Dashboard not loading due to ‘select2’ library conflict with other plugins
- Update: Integrated product specific low stock threshold value in ‘Stock’ column color-coding on WooCommerce Products dashboard (Pro)
- Update: POT file
8.34.0 (15.03.2024)
- Fix: Advanced Search functionality displays variations of products whose parents are not published for ‘Post Status’ column in WooCommerce Products dashboard
- Update: POT file
8.33.0 (08.03.2024)
- Fix: ‘Attributes’ column values doesn’t render properly in Bulk edit panel for WooCommerce Products dashboard (Pro)
- Fix: Simple Search not searching ‘Billing Email’ field properly in WooCommerce Orders dashboard
- Fix: Custom post statuses not visible in the ‘Post Status’ column on the dashboard for any post type
- Fix: Advanced Search query returning cached results
- Update: POT file
8.32.0 (01.03.2024)
- New: WooCommerce 8.6.1 compatible
- Fix: Column tooltip not getting updated after enabling/disabling using show/hide columns
- Fix: ‘increase by/decrease by’ operators for date fields not working properly in Bulk edit functionality (Pro)
- Fix: Undo functionality not working properly for date/datetime fields (Pro)
- Fix: HTML tags in the ‘Description’ and ‘Additional Description’ fields within the exported CSV causing issues during CSV import (Pro)
- Update: POT file
8.31.0 (19.02.2024)
- New: WooCommerce 8.6.0 compatible
- New: Access Privilege Settings – give controlled access to individual users in addition to user roles (Pro)
- Fix: Data not loading for WooCommerce Subscriptions ‘Date’ fields like ‘Schedule End’, ‘Schedule Next Payment’, etc. (Pro)
- Fix: Inline edit, Bulk edit & previous value not getting updated for WooCommerce Subscriptions ‘Date’ fields like ‘Schedule End’, ‘Schedule Next Payment’, etc. (Pro)
- Fix: PHP fatal error when updating ‘Attributes’ field data using Bulk edit on WooCommerce Products dashboard
- Fix: PHP warning when loading ‘Attributes’ field data on WooCommerce Products dashboard
- Update: Improved Access Privilege settings UI/UX (Pro)
- Update: POT file
8.30.0 (02.02.2024)
- New: WooCommerce 8.5.2 compatible
- New: WordPress 6.4.3 compatible
- Fix: WooCommerce Products ‘Stock Status’ column doesn’t update automatically with changes in the ‘Backorders’ column
- Fix: Duplicate values in the ‘Product categories’, and ‘Exclude categories’ WooCommerce Coupons restrictions fields when updating using Bulk edit
- Update: POT file